APPS.PO_LINK_REQ_DIST_PVT dependencies on PO_DISTRIBUTIONS_MERGE_V

Line 181: FROM PO_DISTRIBUTIONS_MERGE_V POD,

177: WHERE INDEX_CHAR1 = 'LINKREQDIST_LINELOCID';
178:
179: CURSOR C_DIST_NUM_MAX_LIST IS
180: SELECT GT.LINE_LOCATION_ID, Nvl(MAX(POD.DISTRIBUTION_NUM),0) MAX_DIST_NUM
181: FROM PO_DISTRIBUTIONS_MERGE_V POD,
182: PO_DISTRIBUTIONS_GT GT
183: WHERE GT.LINE_LOCATION_ID = POD.LINE_LOCATION_ID(+)
184: GROUP BY GT.LINE_LOCATION_ID;
185:

Line 542: FROM PO_DISTRIBUTIONS_MERGE_V POD

538: , ((POD.QUANTITY_ORDERED-NVL(POD.QUANTITY_CANCELLED,0))*POLL.PRICE_OVERRIDE)
539: )
540: )
541:
542: FROM PO_DISTRIBUTIONS_MERGE_V POD
543: WHERE POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
544: AND POLL.DRAFT_ID = POD.DRAFT_ID
545: AND Nvl(POD.DELETE_FLAG, 'N') = 'N'),0)
546: )DAR

Line 823: FROM PO_DISTRIBUTIONS_MERGE_V POD

819: , ((POD.QUANTITY_ORDERED-NVL(POD.QUANTITY_CANCELLED,0))*POLL.PRICE_OVERRIDE)
820: )
821: )
822:
823: FROM PO_DISTRIBUTIONS_MERGE_V POD
824: WHERE POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
825: AND POLL.DRAFT_ID = POD.DRAFT_ID
826: AND Nvl(POD.DELETE_FLAG, 'N') = 'N'),0)
827: )DAR

Line 1299: PO_DISTRIBUTIONS_MERGE_V PLD

1295: FROM
1296: PO_DISTRIBUTIONS_GT GT,
1297: PO_LINES_MERGE_V POL,
1298: PO_LINE_LOCATIONS_MERGE_V PLL,
1299: PO_DISTRIBUTIONS_MERGE_V PLD
1300: WHERE GT.LINE_LOCATION_ID = PLD.LINE_LOCATION_ID AND
1301: GT.DRAFT_ID = PLD.DRAFT_ID AND
1302: PLD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1303: PLL.DRAFT_ID = PLD.DRAFT_ID AND

Line 1715: FROM PO_DISTRIBUTIONS_MERGE_V PLD

1711: AND PDD.DRAFT_ID = L_DRAFT_ID )
1712: UNION ALL
1713: (SELECT PLD.PO_DISTRIBUTION_ID, PLD.CODE_COMBINATION_ID,
1714: PLD.CLM_MISC_LOA
1715: FROM PO_DISTRIBUTIONS_MERGE_V PLD
1716: WHERE PLD.PO_HEADER_ID = L_HEADER_ID
1717: AND PLD.DRAFT_ID = L_DRAFT_ID)
1718: )
1719: ORDER BY PO_DISTRIBUTION_ID ;