Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to report output like below


supplier name date amount

abc software jan/11 10000 /* jan month total transactions*/
abc software feb/12 30000 /* feb month total transactions*/
dell computers jan/13 45000 /* jan month total transactions*/

Answers were Sorted based on User's Feedback



How to report output like below supplier name date amount abc software jan..

Answer / sovan

select supplier_name "supplier name" ,to_char
(trx_date,'mon/yy') "date",amount "amount"||'/*'||to_char(trx_date,'mon')||'
month total transactions */' from <Table_NAME>;

Is This Answer Correct ?    8 Yes 0 No

How to report output like below supplier name date amount abc software jan..

Answer / aditya

Hi,

Just write a report function which takes the date and finds
the month then concatenate it with the text /* (<Month>)
month total transactions*/

Regards,
Aditya

Is This Answer Correct ?    2 Yes 0 No

How to report output like below supplier name date amount abc software jan..

Answer / birla

Aditya Write the code

Is This Answer Correct ?    0 Yes 0 No

How to report output like below supplier name date amount abc software jan..

Answer / ram

select supplier_name ,to_char
(sysdate,'mon/yy'),amount||'/*'||to_char(sysdate,'mon')||'
month total transactions */' from <Table_NAME>;

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Apps Technical Interview Questions

Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232

0 Answers  


What do you understand by a set of books?

0 Answers  


what is meant by boilerplates?

1 Answers  


What multi org tables . example - difference between app table non all table . Po_header and po_headers_all

1 Answers   IBM,


What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,


Can u attach Request set with in the Request set?

2 Answers   Satyam,


What r the type Models in the system parameters of the report?

1 Answers  


how to create requst set in oracle apps and how to send muliple requests at a time,

1 Answers   Genpact,


what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.

3 Answers   Scan Steel,


Presently u are working in which version?

4 Answers   Accenture,


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

0 Answers  


is it possible to run the interface without using oracle apps?

0 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)