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>;

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

Answer / birla

Aditya Write the code

Answer / ram

select supplier_name ,to_char
(sysdate,'mon/yy'),amount||'/*'||to_char(sysdate,'mon')||'
month total transactions */' from <Table_NAME>;

what is organization id

2 Answers   Wipro,

---

Presently u are working in which version?

4 Answers   Accenture,

---

Challenges faced during upgradation of 11i to R12

1 Answers   Infosys, Satyam,

---

in procedure how to return a value

3 Answers  

---

what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?

2 Answers   CTS,

---

---

what is the difference between credit memo and debit memo?...

2 Answers   Sony,

---

Is that Possible To create package Overloading , If Yes Give any Examples

1 Answers   PWC,

---

in ap_terms table what data will be stored

1 Answers  

---

what is pl/sql table and pl/sql records? what is the use of that?

3 Answers   Intelligroup,

---

What is procedure?

3 Answers   IBM,

---

In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?

1 Answers   Accenture,

---

What do you understand by concurrent programs?

0 Answers  

---