eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_DRP dependencies on MSC_ATP_PVT

Line 34: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

30: FROM (
31: SELECT
32: TRUNC(DECODE(D.RECORD_SOURCE,
33: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
34: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
35: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
36: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) SD_DATE,
37: --plan by requestdate,promisedate,scheduledate
38: -1*D.USING_REQUIREMENT_QUANTITY SD_QTY

Line 42: AND D.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id

38: -1*D.USING_REQUIREMENT_QUANTITY SD_QTY
39: FROM MSC_DEMANDS D
40: WHERE D.PLAN_ID = p_plan_id
41: AND D.SR_INSTANCE_ID = p_instance_id
42: AND D.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
43: AND D.ORGANIZATION_ID = p_org_id
44: AND D.ORIGINATION_TYPE NOT IN(1,4,5,7,8,9,11,15,22,28,29,31,48,49,53,70)
45: AND D.USING_REQUIREMENT_QUANTITY <> 0 --4501434
46: -- Ignore Plan Order Demand (Requested Outbound)

Line 51: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

47: -- and Unconstrained Kit Demand for DRP Plans
48: -- Origination Type 1, 48
49: AND TRUNC(DECODE(D.RECORD_SOURCE,
50: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
51: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
52: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
53: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))
54: < TRUNC(NVL(p_itf, DECODE(D.RECORD_SOURCE,
55: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 56: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

52: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
53: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))
54: < TRUNC(NVL(p_itf, DECODE(D.RECORD_SOURCE,
55: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
56: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
57: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
58: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))) + 1))
59: --plan by request date,promise date ,ship date
60: UNION ALL

Line 67: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id

63: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
64: FROM MSC_SUPPLIES S
65: WHERE S.PLAN_ID = p_plan_id
66: AND S.SR_INSTANCE_ID = p_instance_id
67: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
68: AND S.ORGANIZATION_ID = p_org_id
69: -- Exclude Cancelled Supplies 2460645
70: AND NVL(S.DISPOSITION_STATUS_TYPE, 1) <> 2 -- Bug 2460645
71: AND NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) <> 0 -- 1243985

Line 85: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id

81: FROM MSC_SUPPLIES S
82: WHERE S.PLAN_ID = p_plan_id
83: AND S.SOURCE_SR_INSTANCE_ID = p_instance_id
84: AND S.SOURCE_ORGANIZATION_ID = p_org_id
85: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
86: AND NVL(S.DISPOSITION_STATUS_TYPE, 1) <> 2 -- Bug 2460645
87: AND S.ORDER_TYPE = 51 -- Planned Arrival is a Demand in Source Org
88: AND NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) <> 0 -- 1243985
89: AND TRUNC(NVL(S.FIRM_DATE,S.NEW_SHIP_DATE))

Line 188: MSC_ATP_PVT.G_ITEM_INFO_REC.UOM_CODE col16, -- ATP4drp Re-Use Global data.

184: l_null_num col12,
185: l_null_num col13,
186: l_null_num col14,
187: l_null_char col15,
188: MSC_ATP_PVT.G_ITEM_INFO_REC.UOM_CODE col16, -- ATP4drp Re-Use Global data.
189: 1 col17, -- demand
190: DECODE(D.ORIGINATION_TYPE, -200, 53, --4686870
191: 30,DECODE(NVL(D.DEMAND_SOURCE_TYPE, 2), 8, 54,D.ORIGINATION_TYPE),
192: D.ORIGINATION_TYPE) col18, --4568493

Line 202: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

198: l_null_num col23,
199: -1* D.USING_REQUIREMENT_QUANTITY col24,
200: TRUNC(DECODE(D.RECORD_SOURCE,
201: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
202: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
203: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
204: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) col25,
205: --plan by request date,promise date, schedule date
206: l_null_num col26,

Line 227: AND D.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id

223: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
224: WHERE D.PLAN_ID = p_plan_id
225: AND D.SR_INSTANCE_ID = p_instance_id
226: AND D.ORGANIZATION_ID = p_org_id
227: AND D.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
228: AND D.SHIP_TO_SITE_ID = MTPS.PARTNER_SITE_ID(+) --bug3263368
229: AND D.CUSTOMER_ID = MTP.PARTNER_ID(+) --bug3263368
230: AND D.USING_REQUIREMENT_QUANTITY <> 0 --4501434
231: AND D.ORIGINATION_TYPE NOT IN(1,4,5,7,8,9,11,15,22,28,29,31,48,49,52,53,70) -- ignore copy SO for summary enhancement

Line 237: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

233: -- and Unconstrained Kit Demand for DRP Plans
234: -- Origination Type 1, 48
235: AND TRUNC(DECODE(D.RECORD_SOURCE,
236: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
237: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
238: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
239: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))
240: < TRUNC(NVL(p_itf,
241: DECODE(D.RECORD_SOURCE,

Line 243: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

239: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))
240: < TRUNC(NVL(p_itf,
241: DECODE(D.RECORD_SOURCE,
242: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
243: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
244: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
245: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))) + 1))
246: --plan by request date, promise date, schedule date
247: UNION ALL

Line 263: MSC_ATP_PVT.G_ITEM_INFO_REC.UOM_CODE col16, -- ATP4drp Re-Use Global data.

259: l_null_num col12,
260: l_null_num col13,
261: l_null_num col14,
262: l_null_char col15,
263: MSC_ATP_PVT.G_ITEM_INFO_REC.UOM_CODE col16, -- ATP4drp Re-Use Global data.
264: 2 col17, -- supply
265: DECODE(S.ORDER_TYPE , 2,
266: DECODE(NVL(S.SOURCE_ORGANIZATION_ID, S.ORGANIZATION_ID),
267: S.ORGANIZATION_ID, 2, 53),S.ORDER_TYPE) col18,

Line 299: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id

295: FROM
296: MSC_SUPPLIES S
297: WHERE S.PLAN_ID = p_plan_id
298: AND S.SR_INSTANCE_ID = p_instance_id
299: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
300: AND S.ORGANIZATION_ID = p_org_id
301: AND NVL(S.DISPOSITION_STATUS_TYPE, 1) <> 2 -- Bug 2460645
302: AND NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) <> 0 -- 1243985
303: AND TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE))

Line 321: MSC_ATP_PVT.G_ITEM_INFO_REC.UOM_CODE col16, -- ATP4drp Re-Use Global data.

317: l_null_num col12,
318: l_null_num col13,
319: l_null_num col14,
320: l_null_char col15,
321: MSC_ATP_PVT.G_ITEM_INFO_REC.UOM_CODE col16, -- ATP4drp Re-Use Global data.
322: 1 col17, -- demand in source org.
323: DECODE(S.ORDER_TYPE, 51, 53) col18,
324: -- Bug 4052808 For Display of Inbound as Planned Outbound Shipment.
325: l_null_char col19,

Line 355: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id

351: MSC_SUPPLIES S
352: WHERE S.PLAN_ID = p_plan_id
353: AND S.SOURCE_SR_INSTANCE_ID = p_instance_id
354: AND S.SOURCE_ORGANIZATION_ID = p_org_id
355: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
356: AND NVL(S.DISPOSITION_STATUS_TYPE, 1) <> 2 -- Bug 2460645
357: AND S.ORDER_TYPE = 51 -- Planned Arrival is a Demand in Source Org
358: AND NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) <> 0 -- 1243985
359: AND TRUNC(NVL(S.FIRM_DATE,S.NEW_SHIP_DATE))

Line 411: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

407: I.sr_instance_id,
408: I.organization_id,
409: I.inventory_item_id,
410: '@@@' demand_class,
411: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
412: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
413: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))) SD_DATE,
414: --plan by request date, promise date or schedule date -- 2859130
415: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY

Line 541: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

537: I.organization_id,
538: I.inventory_item_id,
539: TRUNC(DECODE(D.RECORD_SOURCE,
540: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
541: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
542: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE))),
543: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) SD_DATE,
544: --plan by request date, promise date or schedule date
545: decode(D.USING_REQUIREMENT_QUANTITY, -- Consider unscheduled orders as dummy supplies

Line 736: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id

732: SD_DATE, SD_QTY
733: FROM MSC_ATP_SUMMARY_SD S
734: WHERE S.PLAN_ID = p_plan_id
735: AND S.SR_INSTANCE_ID = p_instance_id
736: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
737: AND S.ORGANIZATION_ID = p_org_id
738: AND S.SD_DATE < NVL(p_itf, S.SD_DATE + 1)
739:
740: UNION ALL

Line 750: AND D.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id

746: FROM MSC_DEMANDS D,
747: MSC_PLANS P -- For summary enhancement
748: WHERE D.PLAN_ID = p_plan_id
749: AND D.SR_INSTANCE_ID = p_instance_id
750: AND D.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
751: AND D.ORGANIZATION_ID = p_org_id
752: AND D.USING_REQUIREMENT_QUANTITY <> 0 --4501434
753: AND D.ORIGINATION_TYPE NOT IN (1,4,5,7,8,9,11,15,22,28,29,31,48,49,53,70)
754: -- Ignore Plan Order Demand (Requested Outbound)

Line 772: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id

768: FROM MSC_SUPPLIES S,
769: MSC_PLANS P -- For summary enhancement
770: WHERE S.PLAN_ID = p_plan_id
771: AND S.SR_INSTANCE_ID = p_instance_id
772: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
773: AND S.ORGANIZATION_ID = p_org_id
774: AND NVL(S.DISPOSITION_STATUS_TYPE, 1) <> 2
775: AND NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) <> 0
776: AND TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) < NVL(p_itf, TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) + 1)

Line 792: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id

788: MSC_PLANS P -- For summary enhancement
789: WHERE S.PLAN_ID = p_plan_id
790: AND S.SOURCE_SR_INSTANCE_ID = p_instance_id
791: AND S.SOURCE_ORGANIZATION_ID = p_org_id
792: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
793: AND NVL(S.DISPOSITION_STATUS_TYPE, 1) <> 2
794: AND S.ORDER_TYPE = 51 -- Planned Arrival is a Demand in Source Org
795: AND NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) <> 0
796: AND TRUNC(NVL(S.FIRM_DATE,S.NEW_SHIP_DATE)) < NVL(p_itf, TRUNC(NVL(S.FIRM_DATE,S.NEW_SHIP_DATE)) + 1)