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

WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 Answers  


In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  


How to create a link between One dependent value set to another Dependent value set

5 Answers   Indorama, ManSoft System, Syntel, TE Data,


what are the different calculation columns available in reports?

1 Answers  


Hi Experts How to Create a purchase order without a requisition ?

6 Answers   Amdocs, KPMG, Oracle,






what is meant by Drill Down in Discoverer report? why it will be use?

3 Answers   Oracle,


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

0 Answers   KPIT,


What is multi org?

6 Answers   Accenture, CTS,


In interface how u find errors and how to solve. How to fix it?

3 Answers  


testing tools?

0 Answers   BirlaSoft, Convergys,


In support project one ticket alloted which steps follows manualy tell me ?

0 Answers   BEL, Questam,


i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,


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)