APPS.PO_SUPPLY dependencies on PO_DISTRIBUTIONS_ALL

Line 557: , po_distributions_all pd

553: AND ms.supply_source_id IN
554: (
555: SELECT prl.requisition_line_id
556: FROM po_requisition_lines_all prl
557: , po_distributions_all pd
558: WHERE prl.line_location_id = pd.line_location_id
559: AND pd.po_header_id = p_docid
560: );
561:

Line 961: || 'FROM po_distributions_all pd, po_lines_all pl ';

957: sql_dist := 'SELECT pd.po_distribution_id, '
958: || 'pd.quantity_ordered - nvl(pd.quantity_delivered, 0) - nvl(pd.quantity_cancelled, 0), '
959: || 'pl.unit_meas_lookup_code, '
960: || 'pd.line_location_id '
961: || 'FROM po_distributions_all pd, po_lines_all pl ';
962:
963:
964: IF (p_entity_type = 'PO') THEN
965:

Line 1055: FROM po_distributions_all pod

1051:
1052: SELECT NVL(SUM(pod.quantity_ordered - NVL(pod.quantity_delivered, 0)
1053: - NVL(pod.quantity_cancelled, 0)), 0)
1054: INTO l_released_qty
1055: FROM po_distributions_all pod
1056: , po_releases_all por
1057: WHERE pod.source_distribution_id = l_distid
1058: AND pod.po_release_id = por.po_release_id
1059: AND NVL(por.authorization_status, 'IN PROCESS') = 'APPROVED';

Line 1204: FROM po_distributions_all pd,

1200: pd.deliver_to_location_id,
1201: pd.destination_organization_id,
1202: pd.destination_subinventory,
1203: 'Y'
1204: FROM po_distributions_all pd,
1205: po_line_locations_all pll,
1206: po_lines_all pl
1207: WHERE pd.po_distribution_id = l_distid
1208: AND pll.line_location_id = pd.line_location_id

Line 2715: FROM po_distributions_all pd

2711: SET ms.quantity =
2712: (
2713: SELECT ms.quantity +
2714: NVL( sum(nvl(pd.quantity_cancelled,0)),0)
2715: FROM po_distributions_all pd
2716: WHERE pd.po_release_id = p_docid
2717: AND pd.line_location_id = p_shipid
2718: AND pd.source_distribution_id = ms.supply_source_id
2719: )

Line 2746: FROM po_distributions_all pod

2742: d_progress := 30;
2743:
2744: SELECT pod.source_distribution_id, pod.quantity_ordered
2745: BULK COLLECT INTO l_ppo_dist_id_tbl, l_ppo_dist_qty_tbl
2746: FROM po_distributions_all pod
2747: WHERE pod.po_release_id = p_docid
2748: AND (pod.po_line_id IS NOT NULL AND pod.line_location_id IS NOT NULL);
2749:
2750: d_progress := 40;

Line 2758: FROM po_distributions_all pod

2754: SET mts.quantity = l_ppo_dist_qty_tbl(i) -
2755: (
2756: SELECT NVL(sum(pod.quantity_ordered -
2757: NVL(pod.quantity_cancelled, 0)), 0)
2758: FROM po_distributions_all pod
2759: WHERE pod.source_distribution_id = l_ppo_dist_id_tbl(i)
2760: AND pod.po_line_id IS NOT NULL
2761: AND pod.line_location_id IS NOT NULL
2762: )