Open PO's To display the amount billed , ordered amount , etc in oracle apps R12

Open PO's To display the amount billed , ordered amount , etc in Shipment Level


select  
(l.quantity*l.unit_price) "Amount Ordered",
(select aia.invoice_amount
 from ap_invoices_all aia,
      ap_invoice_distributions_all aid
 where aia.invoice_id = aid.invoice_id
 and   aid.po_distribution_id = d.po_distribution_id) "Amount Billed",
gcc.segment1||'-'||gcc.segment2||'-'||gcc.segment3||'-'||gcc.segment4||'-'||gcc.segment5 "Charge account",
ll.ship_to_location_id "Ship to Location",
l.quantity            "quantity",
d.quantity_ordered    "Ordered Quantity",
d.quantity_billed     "Billed Quantity",
d.quantity_delivered  "Received Quantity"
from  
po.po_headers_all h,  
po.po_lines_all l,  
po.po_line_locations_all ll,  
po.po_distributions_all d,
gl_code_combinations   gcc
where h.po_header_id = l.po_header_id  
and  gcc.code_combination_id=d.code_combination_id
and ll.po_line_id = l.po_Line_id  
and ll.line_location_id = d.line_location_id
and h.segment1='8533'
and h.closed_date is null ;

No comments:

Post a Comment

WIP Tables with description

  Table Name Description     WIP_ACCOUNTING_CLASSES stores accounting flexfield information for standard discrete jobs, non-standard asset j...