DBA Data[Home] [Help]

APPS.GMI_UPDATE_ORDER dependencies on RCV_SHIPMENT_LINES

Line 62: from rcv_shipment_lines rsl, oe_order_lines_all oel

58: AND NVL(dd.inv_interfaced_flag , 'N') = 'Y'
59: AND dd.container_flag = 'N'
60: AND dd.source_code = 'OE'
61: AND NOT EXISTS(select 1
62: from rcv_shipment_lines rsl, oe_order_lines_all oel
63: where oel.line_id = dd.source_line_id
64: and rsl.requisition_line_id = oel.source_document_line_id
65: and rsl.comments = 'OPM WDD:'||to_char(dd.delivery_detail_id));
66: