DBA Data[Home] [Help]

APPS.RCV_NORMALIZE_DATA_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 286: and exists (select 'LCM Shipment' from po_line_locations_all pll

282: and (rti.transaction_type = 'RECEIVE'
283: or (rti.transaction_type = 'SHIP'
284: and rti.auto_transact_code in ('RECEIVE','DELIVER'))) -- Bug 8343139
285: and rti.source_document_code = 'PO'
286: and exists (select 'LCM Shipment' from po_line_locations_all pll
287: where pll.line_location_id = rti.po_line_location_id
288: and lcm_flag = 'Y')
289: and (rti.lcm_shipment_line_id is null or rti.unit_landed_cost is null);
290: --

Line 308: and exists (select 'LCM Shipment' from po_line_locations_all pll

304: and (rti.transaction_type = 'RECEIVE'
305: or (rti.transaction_type = 'SHIP'
306: and rti.auto_transact_code in ('RECEIVE','DELIVER'))) -- Bug 8343139
307: and rti.source_document_code = 'PO'
308: and exists (select 'LCM Shipment' from po_line_locations_all pll
309: where pll.line_location_id = rti.po_line_location_id
310: and lcm_flag = 'Y')
311: and (rti.lcm_shipment_line_id is null or rti.unit_landed_cost is null);
312: --