APPS.RCV_NORMALIZE_DATA_PKG dependencies on PO_LINE_LOCATIONS_ALL

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

251: where rti.group_id = p_rti_row.group_id
252: and rti.lpn_group_id is not null
253: and rti.lpn_group_id = p_rti_row.lpn_group_id
254: and rti.source_document_code = 'PO'
255: and exists (select 'LCM Shipment' from po_line_locations_all pll
256: where pll.line_location_id = rti.po_line_location_id
257: and lcm_flag = 'Y')
258: and (rti.lcm_shipment_line_id is null or rti.unit_landed_cost is null);
259: --

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

269: from rcv_transactions_interface rti
270: where rti.group_id = x_rhi_row.group_id
271: and rti.header_interface_id = x_rhi_row.header_interface_id
272: and rti.source_document_code = 'PO'
273: and exists (select 'LCM Shipment' from po_line_locations_all pll
274: where pll.line_location_id = rti.po_line_location_id
275: and lcm_flag = 'Y')
276: and (rti.lcm_shipment_line_id is null or rti.unit_landed_cost is null);
277: --