Oracle Technology
1) write a query to display po_no,po_line_num,po_shipment_number, po_distribution num and charge account code
2) Write query to display code combination segment against charge_account ccid of po _distributions
1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...
No comments:
Post a Comment