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 ment by Global Templates in Oracle.

1 Answers   IBM,


How to generate XML Report with out using rdf?

6 Answers   BirlaSoft, Patni, UST,


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 are the mandatory parameters in suppler Conversion?

1 Answers   Tech Mahindra,


how to make a parameter optional in the query?

2 Answers   Wipro,






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,


explain p2p cycle? what are the tables used for this?

3 Answers   Accenture,


How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,


how to avoid duplicate data while uploading data from flatfile to staging table? some validations

5 Answers   Amdocs,


Form development process?

1 Answers  


what is the invoice matching

2 Answers  


In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,


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)