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
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 |
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 |
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 |
What is ment by Global Templates in Oracle.
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
what are the mandatory parameters in suppler Conversion?
how to make a parameter optional in the query?
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.
explain p2p cycle? what are the tables used for this?
How can u call a standard interface program from sql or pl/sql code?
how to avoid duplicate data while uploading data from flatfile to staging table? some validations
Form development process?
what is the invoice matching
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,