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*/
- 4 Answers
- 8700 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 CUSTOM VIEW AND CUSTOM COMPONENT?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
What is count(*) from po_vendors(any table)?
where to define interorganization transaction charges and what are the different options?
can we get profile values in report without using user exists is it possible how?
How is choreography different from orchestration?
is it possible to run the interface without using oracle apps?
what are the balancing segments in AR?
What is a value set? List its various types.
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
What are the different components of soa suite?
Can we create tables in apps schema?
Which oracle apps version you are very confident in?
tell me the scenarios of the independent in reports
Explain oracle apps architecture.
