APPS.RCV_ROI_PREPROCESSOR dependencies on PO_LINE_LOCATIONS_ALL

Line 163: po_line_locations_all poll

159: NULL
160: ) osa_flag
161: FROM rcv_headers_interface rsh,
162: rcv_transactions_interface rti,
163: po_line_locations_all poll
164: WHERE rsh.asn_type = 'ASBN'
165: AND rsh.header_interface_id = rti.header_interface_id
166: AND poll.line_location_id (+) = rti.po_line_location_id
167: AND rti.processing_status_code = 'RUNNING')

Line 818: FROM po_line_locations_all plla,

814: END IF;
815:
816: SELECT count(*)
817: INTO l_drop_ship_exists
818: FROM po_line_locations_all plla,
819: rcv_transactions_interface rti
820: WHERE rti.header_interface_id = x_header_record.header_record.header_interface_id
821: and rti.po_line_location_id = plla.line_location_id
822: and plla.drop_ship_flag = 'Y';