DBA Data[Home] [Help]

APPS.INV_RCV_RESERVATION_UTIL dependencies on PO_REQUISITION_HEADERS_ALL

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;