APPS.INV_RCV_RESERVATION_UTIL dependencies on PO_LINE_LOCATIONS_ALL

Line 870: FROM po_line_locations_all

866: l_progress := '@@@';
867: BEGIN
868: SELECT 1
869: INTO l_dummy
870: FROM po_line_locations_all
871: WHERE line_location_id = p_cas_mol_rec_tb(1).po_line_location_id
872: FOR UPDATE NOWAIT;
873: EXCEPTION
874: WHEN OTHERS THEN

Line 1334: FROM po_line_locations_all

1330: l_progress := '###';
1331: BEGIN
1332: SELECT 1
1333: INTO l_dummy
1334: FROM po_line_locations_all
1335: WHERE line_location_id = p_cas_mol_rec_tb(1).po_line_location_id
1336: FOR UPDATE NOWAIT;
1337: EXCEPTION
1338: WHEN OTHERS THEN

Line 1991: po_requisition_headers_all prha , po_line_locations_all plla

1987: IF (l_reference = 'PO_LINE_LOCATION_ID') THEN
1988:
1989: SELECT prha.interface_source_line_id INTO l_demand_source_line_id
1990: FROM po_requisition_lines_all prla ,mtl_txn_request_lines mtrl ,
1991: po_requisition_headers_all prha , po_line_locations_all plla
1992: WHERE plla.line_location_id=prla.line_location_id
1993: AND plla.line_location_id = mtrl.reference_id
1994: AND prha.requisition_header_id = prla.requisition_header_id
1995: AND mtrl.line_id=p_cas_mol_rec_tb(1).line_id;