APPS.PO_REQ_LINES_SV dependencies on PO_LINE_LOCATIONS

Line 171: PO_LINE_LOCATIONS POLL

167: X_progress := '010';
168: SELECT COUNT(1)
169: INTO X_row_exists
170: FROM PO_REQUISITION_LINES PORL,
171: PO_LINE_LOCATIONS POLL
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 650: FROM po_line_locations s, po_requisition_lines rl

646: SELECT s.po_header_id, s.po_release_id, s.po_line_id, s.line_location_id,
647: rl.requisition_header_id, rl.requisition_line_id
648: BULK COLLECT INTO l_po_header_id, l_po_release_id, l_po_line_id, l_line_location_id,
649: L_req_header_id, l_req_line_id
650: FROM po_line_locations s, po_requisition_lines rl
651: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
652: AND s.po_header_id = X_entity_id;
653: --
654:

Line 663: FROM po_line_locations

659: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
660: last_update_date = sysdate -- Bug5623016 (updating who column)
661:
662: WHERE line_location_id in (SELECT line_location_id
663: FROM po_line_locations
664: WHERE po_header_id = X_entity_id);
665:
666: ELSIF (X_entity = 'RELEASE') THEN
667: x_progress := '020';

Line 676: FROM po_line_locations s, po_requisition_lines rl

672: SELECT s.po_header_id, s.po_release_id, s.po_line_id, s.line_location_id,
673: rl.requisition_header_id, rl.requisition_line_id
674: BULK COLLECT INTO l_po_header_id, l_po_release_id, l_po_line_id, l_line_location_id,
675: L_req_header_id, l_req_line_id
676: FROM po_line_locations s, po_requisition_lines rl
677: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
678: AND s.po_release_id = X_entity_id;
679: --
680:

Line 688: FROM po_line_locations

684: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
685: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
686: last_update_date = sysdate -- Bug5623016 (updating who column)
687: WHERE line_location_id in (SELECT line_location_id
688: FROM po_line_locations
689: WHERE po_release_id = X_entity_id);
690:
691: ELSIF (X_entity = 'LINE') THEN
692: x_progress := '030';

Line 701: FROM po_line_locations s, po_requisition_lines rl

697: SELECT s.po_header_id, s.po_release_id, s.po_line_id, s.line_location_id,
698: rl.requisition_header_id, rl.requisition_line_id
699: BULK COLLECT INTO l_po_header_id, l_po_release_id, l_po_line_id, l_line_location_id,
700: L_req_header_id, l_req_line_id
701: FROM po_line_locations s, po_requisition_lines rl
702: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
703: AND s.po_line_id = X_entity_id;
704: --
705:

Line 713: FROM po_line_locations

709: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
710: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
711: last_update_date = sysdate -- Bug5623016 (updating who column)
712: WHERE line_location_id in (SELECT line_location_id
713: FROM po_line_locations
714: WHERE po_line_id = X_entity_id);
715:
716: ELSIF (X_entity = 'SHIPMENT') THEN
717: x_progress := '040';

Line 726: FROM po_line_locations s, po_requisition_lines rl

722: SELECT s.po_header_id, s.po_release_id, s.po_line_id, s.line_location_id,
723: rl.requisition_header_id, rl.requisition_line_id
724: BULK COLLECT INTO l_po_header_id, l_po_release_id, l_po_line_id, l_line_location_id,
725: L_req_header_id, l_req_line_id
726: FROM po_line_locations s, po_requisition_lines rl
727: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
728: AND s.line_location_id = X_entity_id;
729: --
730:

Line 738: FROM po_line_locations

734: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
735: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
736: last_update_date = sysdate -- Bug5623016 (updating who column)
737: WHERE line_location_id in (SELECT line_location_id
738: FROM po_line_locations
739: WHERE line_location_id = X_entity_id);
740:
741: END IF;
742: