APPS.PO_REQ_LINES_SV dependencies on PO_LINE_LOCATIONS_ALL

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