APPS.PO_REQ_LINES_SV dependencies on PO_LINE_LOCATIONS

Line 171: PO_LINE_LOCATIONS_ALL POLL -- Bug 8659519

167: X_progress := '010';
168: SELECT COUNT(1)
169: INTO X_row_exists
170: FROM PO_REQUISITION_LINES PORL,
171: PO_LINE_LOCATIONS_ALL POLL -- Bug 8659519
172: WHERE PORL.requisition_header_id = X_req_header_id
173: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id)
174: AND PORL.line_location_id = POLL.line_location_id
175: AND PORL.line_location_id is NOT NULL

Line 745: FROM po_line_locations s, po_requisition_lines rl

741: l_po_line_id,
742: l_line_location_id,
743: L_req_header_id,
744: l_req_line_id
745: FROM po_line_locations s, po_requisition_lines rl
746: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
747: AND s.po_header_id = X_entity_id;
748: --
749:

Line 761: FROM po_line_locations_all pll --Bug 8777237: Looking into the base table instead of po_line_locations

757: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
758: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
759: rl.last_update_date = sysdate -- Bug5623016 (updating who column)
760: WHERE rl.line_location_id in (SELECT pll.line_location_id
761: FROM po_line_locations_all pll --Bug 8777237: Looking into the base table instead of po_line_locations
762: WHERE pll.po_header_id = X_entity_id);
763:
764: ELSIF (X_entity = 'RELEASE') THEN
765: x_progress := '020';

Line 783: FROM po_line_locations s, po_requisition_lines rl

779: l_po_line_id,
780: l_line_location_id,
781: L_req_header_id,
782: l_req_line_id
783: FROM po_line_locations s, po_requisition_lines rl
784: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
785: AND s.po_release_id = X_entity_id;
786: --
787:

Line 799: FROM po_line_locations_all pll--Bug 8777237: Looking into the base table instead of po_line_locations

795: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
796: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
797: rl.last_update_date = sysdate -- Bug5623016 (upda ting who column)
798: WHERE rl.line_location_id in (SELECT pll.line_location_id
799: FROM po_line_locations_all pll--Bug 8777237: Looking into the base table instead of po_line_locations
800: WHERE pll.po_release_id = X_entity_id);
801:
802: ELSIF (X_entity = 'LINE') THEN
803: x_progress := '030';

Line 821: FROM po_line_locations s, po_requisition_lines rl

817: l_po_line_id,
818: l_line_location_id,
819: L_req_header_id,
820: l_req_line_id
821: FROM po_line_locations s, po_requisition_lines rl
822: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
823: AND s.po_line_id = X_entity_id;
824: --
825:

Line 834: AND rl.line_location_id in (SELECT pll.line_location_id FROM po_line_locations_all pll WHERE

830: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)
831: FROM po_requisition_headers_all rh
832: WHERE rh.requisition_header_id = rl.requisition_header_id
833: -- Bug 15875473
834: AND rl.line_location_id in (SELECT pll.line_location_id FROM po_line_locations_all pll WHERE
835: pll.po_line_id = X_entity_id)
836: -- Bug 15875473
837:
838: ),

Line 843: FROM po_line_locations_all pll --Bug 8777237: Looking into the base table instead of po_line_locations

839: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
840: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
841: rl.last_update_date = sysdate -- Bug5623016 (updating who column)
842: WHERE rl.line_location_id IN (SELECT pll.line_location_id
843: FROM po_line_locations_all pll --Bug 8777237: Looking into the base table instead of po_line_locations
844: WHERE pll.po_line_id = X_entity_id);
845:
846: ELSIF (X_entity = 'SHIPMENT') THEN
847: x_progress := '040';

Line 865: FROM po_line_locations s, po_requisition_lines rl

861: l_po_line_id,
862: l_line_location_id,
863: L_req_header_id,
864: l_req_line_id
865: FROM po_line_locations s, po_requisition_lines rl
866: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
867: AND s.line_location_id = X_entity_id;
868: --
869:

Line 882: FROM po_line_locations_all pll --Bug 8777237: Looking into the base table instead of po_line_locations

878: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
879: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
880: rl.last_update_date = SYSDATE -- Bug5623016 (updating who column)
881: WHERE rl.line_location_id IN (SELECT pll.line_location_id
882: FROM po_line_locations_all pll --Bug 8777237: Looking into the base table instead of po_line_locations
883: WHERE pll.line_location_id = X_entity_id);
884: END IF;
885:
886: --