DBA Data[Home] [Help]

APPS.OE_DROP_SHIP_GRP dependencies on RCV_TRANSACTIONS

Line 671: rcv_transactions rt

667: SELECT ol.line_id
668: INTO l_line_id
669: FROM oe_order_lines_all ol,
670: oe_drop_ship_sources od,
671: rcv_transactions rt
672: WHERE ol.line_id = od.line_id
673: AND ol.source_type_code = 'EXTERNAL'
674: AND od.po_header_id = rt.po_header_id
675: AND od.po_line_id = rt.po_line_id

Line 835: rcv_transactions RT

831: SELECT MAX(OL.line_id)
832: INTO x_line_id
833: FROM oe_order_lines_all OL,
834: oe_drop_ship_sources OD,
835: rcv_transactions RT
836: WHERE OL.line_id = OD.line_id
837: AND OL.source_type_code = 'EXTERNAL'
838: AND OD.po_header_id = RT.po_header_id
839: AND OD.po_line_id = RT.po_line_id