APPS.PO_CREATE_ASBN_INVOICE dependencies on RCV_SHIPMENT_LINES

Line 81: from rcv_shipment_lines rsl

77: NVL(rsh.invoice_status_code, 'PENDING') IN ('PENDING', 'REJECTED') and
78: rsh.shipment_header_id = p_shipment_header_id and
79: poh.po_header_id = (
80: select rsl.po_header_id
81: from rcv_shipment_lines rsl
82: where rsl.shipment_header_id = rsh.shipment_header_id
83: and rownum = 1 );
84:
85:

Line 108: rcv_shipment_lines rsl

104: pll.match_option
105: from
106: po_line_locations pll,
107: po_lines pol,
108: rcv_shipment_lines rsl
109: where
110: rsl.shipment_header_id = p_shipment_header_id and
111: pll.line_location_id = rsl.po_line_location_id and
112: pol.po_line_id = rsl.po_line_id and