DBA Data[Home] [Help]

APPS.PO_GML_DB_COMMON dependencies on RCV_SHIPMENT_LINES

Line 671: rcv_shipment_lines rsl

667: l_receipt_source_code,
668: l_parent_transaction_id,
669: l_comments
670: FROM rcv_transactions_interface rti,
671: rcv_shipment_lines rsl
672: WHERE rti.shipment_line_id = rsl.shipment_line_id(+) and
673: rti.interface_transaction_id = p_interface_trx_id;
674:
675: EXCEPTION

Line 731: from rcv_shipment_lines rs, rcv_transactions rt

727: BEGIN
728:
729: select rs.line_num
730: into l_line_num
731: from rcv_shipment_lines rs, rcv_transactions rt
732: where rt.interface_transaction_id = p_interface_trx_id
733: and rs.shipment_header_id = rt.shipment_header_id
734: and rs.shipment_line_id = rt.shipment_line_id
735: and rt.transaction_type IN('DELIVER','RETURN TO RECEIVING','CORRECT');