APPS.PO_OM_INTEGRATION_GRP dependencies on PO_REQUISITION_LINES_ALL

Line 362: FROM po_requisition_lines_all

358:
359:
360: SELECT unit_meas_lookup_code, secondary_unit_of_measure
361: INTO l_request_unit_of_measure, l_request_secondary_uom
362: FROM po_requisition_lines_all
363: WHERE requisition_line_id = p_req_line_id(i);
364:
365: */
366:

Line 495: FROM po_requisition_lines_all

491: -- Bug 3639067 START
492: -- Only synchronize if the line is flagged as drop ship.
493: SELECT drop_ship_flag
494: INTO l_drop_ship_flag
495: FROM po_requisition_lines_all
496: WHERE requisition_line_id = p_req_line_id(i);
497:
498: IF (l_drop_ship_flag = 'Y') THEN
499: -- Bug 3639067 END

Line 847: FROM po_requisition_lines_all PRL

843: FORALL i IN 1..p_req_line_id.COUNT
844: INSERT INTO po_session_gt
845: (key, num1, num2)
846: SELECT l_session_gt_key, PRL.requisition_line_id, PRL.requisition_header_id
847: FROM po_requisition_lines_all PRL
848: WHERE PRL.requisition_line_id = p_req_line_id(i)
849: AND PRL.drop_ship_flag = 'Y';
850:
851: -- SQL What: Select the req line and header IDs from PO_SESSION_GT into