APPS.INV_LABEL_PVT1 dependencies on PO_DISTRIBUTIONS_ALL

Line 712: -- , po_distributions_all pod --Commented as part of Bug# 3586116

708: * , mtl_transaction_lot_numbers mtln -- Added as part of Bug# 4186856
709: */
710: , rcv_shipment_lines rsl
711: , po_lines_trx_v pol -- CLM project, bug 9403291
712: -- , po_distributions_all pod --Commented as part of Bug# 3586116
713: , po_headers_trx_v pha -- CLM project, bug 9403291
714: , rcv_shipment_headers rsh
715: , po_line_locations_trx_v pll -- CLM project, bug 9403291
716: , po_vendors pov

Line 910: -- , po_distributions_all pod --Commented as part of Bug# 3586116

906: FROM rcv_transactions rt
907: , mtl_transaction_lot_numbers mtln
908: , rcv_shipment_lines rsl
909: , po_lines_trx_v pol -- CLM project, bug 9403291
910: -- , po_distributions_all pod --Commented as part of Bug# 3586116
911: , po_headers_trx_v pha -- CLM project, bug 9403291
912: , rcv_shipment_headers rsh
913: , po_line_locations_trx_v pll -- CLM project, bug 9403291
914: , po_vendors pov

Line 1093: -- , po_distributions_all pod --Commented as part of Bug# 3586116

1089: FROM rcv_transactions rt
1090: , mtl_transaction_lot_numbers mtln
1091: , rcv_shipment_lines rsl
1092: , po_lines_trx_v pol -- CLM project, bug 9403291
1093: -- , po_distributions_all pod --Commented as part of Bug# 3586116
1094: , po_headers_trx_v pha -- CLM project, bug 9403291
1095: , rcv_shipment_headers rsh
1096: , po_line_locations_trx_v pll -- CLM project, bug 9403291
1097: , po_vendors pov

Line 1917: FROM po_distributions_all pod,

1913:
1914: /* For Bug 4916450 defined the cursor pod_project_task */
1915: CURSOR pod_project_task IS
1916: SELECT DISTINCT pod.project_id, pod.task_id
1917: FROM po_distributions_all pod,
1918: rcv_transactions rt
1919: WHERE pod.po_header_id = rt.po_header_id
1920: AND pod.po_line_id = rt.po_line_id
1921: AND pod.line_location_id = rt.po_line_location_id

Line 3299: -- Start of fix for 8533306. Fetching the project/task id from PO_Distributions_all for the Direct Delivery.

3295: END IF;
3296:
3297: /* End of fix for 4916450 */
3298:
3299: -- Start of fix for 8533306. Fetching the project/task id from PO_Distributions_all for the Direct Delivery.
3300: IF ( l_is_wms_org = FALSE AND l_routing_header_id = 3 ) THEN
3301:
3302: BEGIN
3303:

Line 3308: FROM po_distributions_all

3304: IF (Nvl(l_project_id,-1) = -1 AND Nvl(l_task_id,-1) = -1) THEN
3305:
3306: SELECT project_id , task_id
3307: INTO l_project_id, l_task_id
3308: FROM po_distributions_all
3309: WHERE po_distribution_id = l_po_distribution_id;
3310:
3311: IF (l_debug = 1) THEN
3312: TRACE('Project: ' || l_project_id || 'Task: ' || l_task_id);