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_clm_v 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 985: || 'FROM po_distributions_all pd, po_lines_all pl ';

981: sql_dist := 'SELECT pd.po_distribution_id, '
982: || 'pd.quantity_ordered - nvl(pd.quantity_delivered, 0) - nvl(pd.quantity_cancelled, 0), '
983: || 'pl.unit_meas_lookup_code, '
984: || 'pd.line_location_id '
985: || 'FROM po_distributions_all pd, po_lines_all pl ';
986:
987:
988: IF (p_entity_type = 'PO') THEN
989:

Line 1027: FROM po_distributions_all pd

1023:
1024: --
1025: SELECT COUNT(po_distribution_id)
1026: INTO l_dist_count
1027: FROM po_distributions_all pd
1028: WHERE pd.line_location_id = b_entity_id;
1029: --
1030:
1031: END IF; -- IF p_entity_type = ...

Line 1086: FROM po_distributions_all pod

1082:
1083: SELECT NVL(SUM(pod.quantity_ordered - NVL(pod.quantity_delivered, 0)
1084: - NVL(pod.quantity_cancelled, 0)), 0)
1085: INTO l_released_qty
1086: FROM po_distributions_all pod
1087: , po_releases_all por
1088: WHERE pod.source_distribution_id = l_distid
1089: AND pod.po_release_id = por.po_release_id
1090: AND NVL(por.authorization_status, 'IN PROCESS') = 'APPROVED';

Line 1318: FROM po_distributions_all pd,

1314: pd.deliver_to_location_id,
1315: pd.destination_organization_id,
1316: pd.destination_subinventory,
1317: 'Y'
1318: FROM po_distributions_all pd,
1319: po_line_locations_all pll,
1320: po_lines_all pl
1321: WHERE pd.po_distribution_id = l_distid
1322: AND pll.line_location_id = pd.line_location_id

Line 2913: FROM po_distributions_all pd

2909: SET ms.quantity =
2910: (
2911: SELECT ms.quantity +
2912: NVL( sum(nvl(pd.quantity_cancelled,0)),0)
2913: FROM po_distributions_all pd
2914: WHERE pd.po_release_id = p_docid
2915: AND pd.line_location_id = p_shipid
2916: AND pd.source_distribution_id = ms.supply_source_id
2917: )

Line 2944: FROM po_distributions_all pod

2940: d_progress := 30;
2941:
2942: SELECT pod.source_distribution_id, pod.quantity_ordered
2943: BULK COLLECT INTO l_ppo_dist_id_tbl, l_ppo_dist_qty_tbl
2944: FROM po_distributions_all pod
2945: WHERE pod.po_release_id = p_docid
2946: AND (pod.po_line_id IS NOT NULL AND pod.line_location_id IS NOT NULL);
2947:
2948: d_progress := 40;

Line 2956: FROM po_distributions_all pod

2952: SET mts.quantity = l_ppo_dist_qty_tbl(i) -
2953: (
2954: SELECT NVL(sum(pod.quantity_ordered -
2955: NVL(pod.quantity_cancelled, 0)), 0)
2956: FROM po_distributions_all pod
2957: WHERE pod.source_distribution_id = l_ppo_dist_id_tbl(i)
2958: AND pod.po_line_id IS NOT NULL
2959: AND pod.line_location_id IS NOT NULL
2960: )