DBA Data[Home] [Help]

APPS.INV_RCV_RESERVATION_UTIL dependencies on PO_REQUISITION_LINES_ALL

Line 1356: FROM po_requisition_lines_all

1352: l_progress := '###';
1353: BEGIN
1354: SELECT requisition_header_id
1355: INTO l_requisition_header_id
1356: FROM po_requisition_lines_all
1357: WHERE requisition_line_id = p_cas_mol_rec_tb(1).requisition_line_id
1358: FOR UPDATE NOWAIT;
1359:
1360: l_progress := '###';

Line 1990: FROM po_requisition_lines_all prla ,mtl_txn_request_lines mtrl ,

1986:
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