How to report output like below supplier name date amount abc

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*/

Question Posted / msuman5577

4 Answers
8522 Views
Satyam, I also Faced
E-Mail Answers

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

Explain oracle apps architecture.

0 Answers

what is global tempory table?

1 Answers BirlaSoft,

What are the tables in GL?

3 Answers Convergys,

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,

What is the maximum number of statements that can be specified in a trigger statement?

1 Answers Oracle,

A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

0 Answers Accenture,

what is difference between d2k report and oracle apps report

2 Answers iFlex, TCS,

what is meant by Table space?

2 Answers

what is the data type of lexical parameter?

5 Answers Wipro,

how many layout sections are tehre in layout editor?

1 Answers

What are the requests groups?

3 Answers

what is difference between po_headers_all and po_headers

2 Answers NTT Data,

For more Oracle Apps Technical Interview Questions Click Here