APPS.INV_RCV_COMMON_APIS dependencies on PO_REQUISITION_HEADERS

Line 365: FROM po_requisition_headers prh, po_requisition_lines prl, rcv_shipment_lines rsl, mtl_system_items msi1, mtl_system_items msi2

361:
362: IF p_req_header_id IS NOT NULL THEN
363: SELECT 'N'
364: INTO l_lot_ser_flag
365: FROM po_requisition_headers prh, po_requisition_lines prl, rcv_shipment_lines rsl, mtl_system_items msi1, mtl_system_items msi2
366: WHERE prh.requisition_header_id = p_req_header_id
367: AND prl.requisition_header_id = prh.requisition_header_id
368: AND rsl.requisition_line_id = prl.requisition_line_id
369: AND rsl.item_id = msi1.inventory_item_id

Line 7258: FROM po_requisition_headers_all

7254: l_progress := '10';
7255: IF (p_req_id IS NOT NULL) AND (x_lpn_flag = 'Y') THEN
7256: SELECT segment1
7257: INTO l_req_num
7258: FROM po_requisition_headers_all
7259: WHERE requisition_header_id = p_req_id;
7260:
7261: IF (l_debug = 1) THEN
7262: print_debug('segment1 : ' || l_req_num, 1);