APPS.MSC_AATP_REQ dependencies on MSC_ALLOC_DEMANDS

Line 164: FROM MSC_ALLOC_DEMANDS AD,

160: SELECT TRUNC(AD.DEMAND_DATE) SD_DATE,
161: decode(AD.ALLOCATED_QUANTITY, -- Consider unscheduled orders as dummy supplies
162: 0,NVL(AD.OLD_ALLOCATED_QUANTITY,0), -- For summary enhancement --5283809
163: -1 * AD.ALLOCATED_QUANTITY) SD_QTY
164: FROM MSC_ALLOC_DEMANDS AD,
165: MSC_PLANS P -- For summary enhancement
166: WHERE AD.PLAN_ID = p_plan_id
167: AND AD.SR_INSTANCE_ID = p_instance_id
168: AND AD.INVENTORY_ITEM_ID = l_inv_item_id

Line 244: FROM MSC_ALLOC_DEMANDS AD

240: l_current_atp.atp_qty
241: FROM (
242: SELECT TRUNC(AD.DEMAND_DATE) SD_DATE,
243: -1 * AD.ALLOCATED_QUANTITY SD_QTY
244: FROM MSC_ALLOC_DEMANDS AD
245: WHERE AD.PLAN_ID = p_plan_id
246: AND AD.SR_INSTANCE_ID = p_instance_id
247: AND AD.INVENTORY_ITEM_ID = l_inv_item_id
248: AND AD.ORGANIZATION_ID = p_organization_id

Line 420: FROM MSC_ALLOC_DEMANDS AD,

416: MTP.PARTNER_NAME, --bug3263368
417: AD.DEMAND_CLASS, --bug3263368
418: AD.REQUEST_DATE --bug3263368
419:
420: FROM MSC_ALLOC_DEMANDS AD,
421: MSC_TRADING_PARTNERS MTP,--bug3263368
422: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
423:
424: WHERE AD.PLAN_ID = p_plan_id

Line 1189: FROM MSC_ALLOC_DEMANDS AD,

1185: decode(AD.ALLOCATED_QUANTITY, -- Consider unscheduled orders as dummy supplies
1186: 0, nvl(OLD_ALLOCATED_QUANTITY,0), --4658238 -- For summary enhancement
1187: -1 * AD.ALLOCATED_QUANTITY) SD_QTY,
1188: AD.DEMAND_CLASS
1189: FROM MSC_ALLOC_DEMANDS AD,
1190: MSC_PLANS P -- For summary enhancement
1191: WHERE AD.PLAN_ID = p_plan_id
1192: AND AD.SR_INSTANCE_ID = p_instance_id
1193: AND AD.INVENTORY_ITEM_ID = l_inv_item_id

Line 1279: FROM MSC_ALLOC_DEMANDS AD

1275: (
1276: SELECT TRUNC(AD.DEMAND_DATE) SD_DATE,
1277: -1 * AD.ALLOCATED_QUANTITY SD_QTY,
1278: AD.DEMAND_CLASS
1279: FROM MSC_ALLOC_DEMANDS AD
1280: WHERE AD.PLAN_ID = p_plan_id
1281: AND AD.SR_INSTANCE_ID = p_instance_id
1282: AND AD.INVENTORY_ITEM_ID = l_inv_item_id
1283: AND AD.ORGANIZATION_ID = p_organization_id