[Home] [Help]
180: SELECT TRUNC(SA.SUPPLY_DATE) SD_DATE,
181: decode(SA.ALLOCATED_QUANTITY, -- Consider deleted stealing records as dummy demands
182: 0, -1 * (NVL(OLD_ALLOCATED_QUANTITY,0)), -- For summary enhancement --5283809
183: SA.ALLOCATED_QUANTITY) SD_QTY
184: FROM MSC_ALLOC_SUPPLIES SA,
185: MSC_PLANS P -- For summary enhancement
186: WHERE SA.PLAN_ID = p_plan_id
187: AND SA.SR_INSTANCE_ID = p_instance_id
188: AND SA.INVENTORY_ITEM_ID = l_inv_item_id
252: -- join to msc_calendar_dates is not needed.
253: UNION ALL
254: SELECT TRUNC(SA.SUPPLY_DATE) SD_DATE,
255: SA.ALLOCATED_QUANTITY SD_QTY
256: FROM MSC_ALLOC_SUPPLIES SA
257: WHERE SA.PLAN_ID = p_plan_id
258: AND SA.SR_INSTANCE_ID = p_instance_id
259: AND SA.INVENTORY_ITEM_ID = l_inv_item_id
260: AND SA.ORGANIZATION_ID = p_organization_id
480: MTP.PARTNER_NAME, --bug3684383
481: SA.DEMAND_CLASS, --bug3684383
482: null --bug3684383
483:
484: FROM MSC_ALLOC_SUPPLIES SA,
485: MSC_TRADING_PARTNERS MTP,--bug3684383
486: MSC_TRADING_PARTNER_SITES MTPS --bug3684383
487: WHERE SA.PLAN_ID = p_plan_id
488: AND SA.SR_INSTANCE_ID = p_instance_id
1208: decode(SA.ALLOCATED_QUANTITY, -- Consider deleted stealing records as dummy demands
1209: 0, -1 * (NVL(OLD_ALLOCATED_QUANTITY,0)), -- For summary enhancement --5283809
1210: SA.ALLOCATED_QUANTITY) SD_QTY ,
1211: SA.DEMAND_CLASS
1212: FROM MSC_ALLOC_SUPPLIES SA,
1213: MSC_PLANS P -- For summary enhancement
1214: WHERE SA.PLAN_ID = p_plan_id
1215: AND SA.SR_INSTANCE_ID = p_instance_id
1216: AND SA.INVENTORY_ITEM_ID = l_inv_item_id
1293:
1294: SELECT TRUNC(SA.SUPPLY_DATE) SD_DATE,
1295: SA.ALLOCATED_QUANTITY SD_QTY,
1296: SA.DEMAND_CLASS
1297: FROM MSC_ALLOC_SUPPLIES SA
1298: WHERE SA.PLAN_ID = p_plan_id
1299: AND SA.SR_INSTANCE_ID = p_instance_id
1300: AND SA.INVENTORY_ITEM_ID = l_inv_item_id
1301: AND SA.ORGANIZATION_ID = p_organization_id
2074: p_demand_source_type,--cmro
2075: --bug3684383
2076: p_order_number);
2077: IF PG_DEBUG in ('Y', 'C') THEN
2078: msc_sch_wb.atp_debug('Get_Forward_Material_Atp: ' || 'after insert into msc_alloc_supplies-Stealing Info' || l_transaction_id);
2079: END IF;
2080: ELSE
2081: l_pf_stealing_qty := LEAST(l_used_dc_qty(i)-NVL(l_used_dc_mem_qty(i), 0), l_stealing_quantity);
2082: l_mem_stealing_qty := l_stealing_quantity - l_pf_stealing_qty;