DBA Data[Home] [Help]

APPS.CLN_NTFYINVC_PKG dependencies on OE_ORDER_LINES

Line 687: FROM oe_order_headers oh, oe_order_lines ol

683: BEGIN
684:
685: SELECT ol.orig_sys_document_ref,ol.orig_sys_line_ref, ol.orig_sys_shipment_ref
686: INTO x_po_num, x_po_line_num,x_po_ship_num
687: FROM oe_order_headers oh, oe_order_lines ol
688: WHERE oh.org_id = ol.org_id
689: AND oh.header_id = ol.header_id
690: AND oh.org_id = trim(p_org_id)
691: AND oh.order_number = to_number(trim(p_so_num))