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 |
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 do you understand by a set of books?
what is meant by boilerplates?
What multi org tables . example - difference between app table non all table . Po_header and po_headers_all
What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter
Can u attach Request set with in the Request set?
What r the type Models in the system parameters of the report?
how to create requst set in oracle apps and how to send muliple requests at a time,
what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.
Presently u are working in which version?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
is it possible to run the interface without using oracle apps?