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*/
- 4 Answers
- 7254 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is pay run id ?
Do you know what are user profiles in apps. Any examples you can give?
What is a flexfield? List out its types.
Can we create tables in apps schema?
What are file in oracle.
Which oracle apps version you are very confident in?
Explain oracle apps architecture.
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
List the types of flexfield?
Can you define an erp system?
How is choreography different from orchestration?
Do you know what is applysys in oracle application database schema, what is apps?
tell my any difficult situtation you solved in your experience in your company?
In support project one ticket alloted which steps follows manualy tell me ?
List the various types of value set.
