APPS.PO_CREATE_ASBN_INVOICE dependencies on RCV_SHIPMENT_HEADERS

Line 84: rcv_shipment_headers rsh

80: poh.org_id
81: from
82: po_vendor_sites pvss,
83: po_headers poh,
84: rcv_shipment_headers rsh
85: where
86: poh.vendor_site_id = pvss.vendor_site_id and
87: poh.pcard_id is null and
88: rsh.receipt_source_code = 'VENDOR' and

Line 311: update rcv_shipment_headers

307:
308: /* Bug 12631722: Upon ASBN creation, RSH and RSL have to be set as
309: * INVOICED */
310:
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