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)
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 187: MSC_ATP_PVT.G_ITEM_INFO_REC.UOM_CODE col16, -- ATP4drp Re-Use Global data.

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

Line 201: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

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

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

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

Line 236: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

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

Line 242: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

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

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

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

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

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

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

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

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

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

Line 410: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

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

Line 540: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

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

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

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

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

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

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

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

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

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