APPS.WIP_JOBCLOSE_PRIV dependencies on PO_DISTRIBUTIONS_ALL

Line 1267: PO_DISTRIBUTIONS_ALL PD,

1263: AND EXISTS
1264: (SELECT '1'
1265: FROM PO_RELEASES_ALL PR,
1266: PO_HEADERS_ALL PH,
1267: PO_DISTRIBUTIONS_ALL PD,
1268: PO_LINE_LOCATIONS_ALL PL
1269: WHERE PD.WIP_ENTITY_ID = wdct.WIP_ENTITY_ID
1270: AND PD.DESTINATION_ORGANIZATION_ID = p_organization_id
1271: AND pd.po_line_id IS NOT NULL

Line 1394: PO_DISTRIBUTIONS_ALL PD1

1390: AND wdct.ORGANIZATION_ID = p_organization_id
1391: AND EXISTS
1392: (SELECT '1'
1393: FROM PO_LINE_LOCATIONS_ALL PLL,
1394: PO_DISTRIBUTIONS_ALL PD1
1395: WHERE PLL.LINE_LOCATION_ID = PD1.LINE_LOCATION_ID
1396: AND PD1.WIP_ENTITY_ID = WDCT.WIP_ENTITY_ID
1397: AND PD1.DESTINATION_ORGANIZATION_ID = p_organization_id
1398: AND PLL.QUANTITY_RECEIVED >

Line 1400: FROM PO_DISTRIBUTIONS_ALL PD2

1396: AND PD1.WIP_ENTITY_ID = WDCT.WIP_ENTITY_ID
1397: AND PD1.DESTINATION_ORGANIZATION_ID = p_organization_id
1398: AND PLL.QUANTITY_RECEIVED >
1399: (SELECT SUM(QUANTITY_DELIVERED)
1400: FROM PO_DISTRIBUTIONS_ALL PD2
1401: WHERE PD2.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
1402: AND PD2.LINE_LOCATION_ID IS NOT NULL
1403: AND PD2.PO_LINE_ID IS NOT NULL)
1404: );