APPS.PO_CREATE_ASBN_INVOICE dependencies on RCV_SHIPMENT_LINES

Line 94: from rcv_shipment_lines rsl

90: NVL(rsh.invoice_status_code, 'PENDING') IN ('PENDING', 'REJECTED') and
91: rsh.shipment_header_id = p_shipment_header_id and
92: poh.po_header_id = (
93: select rsl.po_header_id
94: from rcv_shipment_lines rsl
95: where rsl.shipment_header_id = rsh.shipment_header_id
96: and rownum = 1 );
97:
98:

Line 121: rcv_shipment_lines rsl

117: pll.match_option
118: from
119: po_line_locations pll,
120: po_lines pol,
121: rcv_shipment_lines rsl
122: where
123: rsl.shipment_header_id = p_shipment_header_id and
124: pll.line_location_id = rsl.po_line_location_id and
125: pol.po_line_id = rsl.po_line_id and

Line 315: update rcv_shipment_lines

311: update rcv_shipment_headers
312: set invoice_status_code = 'INVOICED'
313: where shipment_header_id = p_shipment_header_id;
314:
315: update rcv_shipment_lines
316: set invoice_status_code = 'INVOICED'
317: where shipment_header_id = p_shipment_header_id;
318:
319: end if;