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_PF dependencies on MSC_AATP_PVT

Line 3328: msc_sch_wb.atp_debug('Set_Alloc_Rule_Variables: G_HIERARCHY_PROFILE: ' || MSC_AATP_PVT.G_HIERARCHY_PROFILE);

3324: msc_sch_wb.atp_debug('Set_Alloc_Rule_Variables: p_org_id: ' || p_org_id);
3325: msc_sch_wb.atp_debug('Set_Alloc_Rule_Variables: p_demand_class: ' || p_demand_class);
3326: msc_sch_wb.atp_debug('Set_Alloc_Rule_Variables: p_atf_date: ' || p_atf_date);
3327: msc_sch_wb.atp_debug('Set_Alloc_Rule_Variables: G_ALLOCATION_METHOD: ' || MSC_ATP_PVT.G_ALLOCATION_METHOD);
3328: msc_sch_wb.atp_debug('Set_Alloc_Rule_Variables: G_HIERARCHY_PROFILE: ' || MSC_AATP_PVT.G_HIERARCHY_PROFILE);
3329: END IF;
3330:
3331: -- Initializing API return code
3332: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3338: IF MSC_AATP_PVT.G_HIERARCHY_PROFILE = 1 THEN

3334: IF MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
3335: /* Demand priority allocated ATP
3336: Here we always use allocation rule from family inside/outside ATF
3337: */
3338: IF MSC_AATP_PVT.G_HIERARCHY_PROFILE = 1 THEN
3339: MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF := 'N';
3340: MSC_ATP_PVT.G_PF_RULE_OUTSIDE_ATF := 'Y';
3341: END IF;
3342: ELSE

Line 3358: IF MSC_AATP_PVT.G_HIERARCHY_PROFILE = 1 THEN

3354: IF PG_DEBUG in ('Y', 'C') THEN
3355: msc_sch_wb.atp_debug('Set_Alloc_Rule_Variables: ' || 'Determine whether rule exist for member item within ATF');
3356: END IF;
3357:
3358: IF MSC_AATP_PVT.G_HIERARCHY_PROFILE = 1 THEN
3359: BEGIN
3360: SELECT allocation_percent
3361: INTO l_alloc_percent
3362: FROM msc_item_hierarchy_mv

Line 3481: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,

3477: SELECT --TRUNC(AD.DEMAND_DATE) SD_DATE, --bug3099066
3478: GREATEST(TRUNC(AD.DEMAND_DATE),p_sys_next_date) SD_DATE,--3099066
3479: --bug3333114 removed trunc from p_sys_next_date as it is already trucate
3480: -1* AD.ALLOCATED_QUANTITY*
3481: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,
3482: 1, decode(AD.Original_Origination_Type,
3483: 6, decode(AD.SOURCE_ORGANIZATION_ID,
3484: NULL, DECODE(AD.DEMAND_CLASS, null, null,
3485: DECODE(p_demand_class, '-1',

Line 3643: DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,

3639: p_family_id)),
3640: p_org_id,
3641: p_instance_id,
3642: AD.Original_Origination_Type,
3643: DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,
3644: 1, decode(AD.Original_Origination_Type,
3645: 6, decode(AD.SOURCE_ORGANIZATION_ID,
3646: NULL, DECODE(AD.DEMAND_CLASS, null, null,
3647: DECODE(p_demand_class, '-1',

Line 3803: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,

3799: UNION ALL
3800: SELECT --TRUNC(SA.SUPPLY_DATE) SD_DATE, --bug3099066
3801: GREATEST(TRUNC(SA.SUPPLY_DATE),p_sys_next_date) SD_DATE,--3099066
3802: SA.ALLOCATED_QUANTITY*
3803: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,
3804: 1, DECODE(SA.DEMAND_CLASS, null, null,
3805: DECODE(p_demand_class, '-1',
3806: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
3807: null,

Line 3885: AND decode(MIHM.level_id (+),-1,1,2) = decode(MSC_AATP_PVT.G_HIERARCHY_PROFILE,1,1,2)

3881: 'N', p_family_id,
3882: SA.INVENTORY_ITEM_ID) = MIHM.INVENTORY_ITEM_ID(+)
3883: AND SA.SR_INSTANCE_ID = MIHM.SR_INSTANCE_ID (+)
3884: AND SA.ORGANIZATION_ID = MIHM.ORGANIZATION_ID (+)
3885: AND decode(MIHM.level_id (+),-1,1,2) = decode(MSC_AATP_PVT.G_HIERARCHY_PROFILE,1,1,2)
3886: AND TRUNC(SA.SUPPLY_DATE) >= MIHM.effective_date (+)
3887: AND TRUNC(SA.SUPPLY_DATE) <= MIHM.disable_date (+)
3888: AND MIHM.demand_class (+) = p_demand_class
3889: )

Line 3950: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,

3946: SELECT --TRUNC(AD.DEMAND_DATE) SD_DATE,
3947: GREATEST(TRUNC(AD.DEMAND_DATE),p_sys_next_date) SD_DATE,--3099066
3948: -1* AD.ALLOCATED_QUANTITY UNALLOC_SD_QTY,
3949: -1* AD.ALLOCATED_QUANTITY*
3950: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,
3951: 1, decode(AD.Original_Origination_Type,
3952: 6, decode(AD.SOURCE_ORGANIZATION_ID,
3953: NULL, DECODE(AD.DEMAND_CLASS, null, null,
3954: DECODE(p_demand_class, '-1',

Line 4111: DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,

4107: p_family_id)),
4108: p_org_id,
4109: p_instance_id,
4110: AD.Original_Origination_Type,
4111: DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,
4112: 1, decode(AD.Original_Origination_Type,
4113: 6, decode(AD.SOURCE_ORGANIZATION_ID,
4114: NULL, DECODE(AD.DEMAND_CLASS, null, null,
4115: DECODE(p_demand_class, '-1',

Line 4273: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,

4269: SELECT --TRUNC(SA.SUPPLY_DATE) SD_DATE,
4270: GREATEST(TRUNC(SA.SUPPLY_DATE),p_sys_next_date) SD_DATE,--3099066
4271: SA.ALLOCATED_QUANTITY UNALLOC_SD_QTY,
4272: SA.ALLOCATED_QUANTITY*
4273: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,
4274: 1, DECODE(SA.DEMAND_CLASS, null, null,
4275: DECODE(p_demand_class, '-1',
4276: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
4277: null,

Line 4355: AND decode(MIHM.level_id (+),-1,1,2) = decode(MSC_AATP_PVT.G_HIERARCHY_PROFILE,1,1,2)

4351: 'N', p_family_id,
4352: sa.INVENTORY_ITEM_ID) = MIHM.INVENTORY_ITEM_ID(+)
4353: AND sa.SR_INSTANCE_ID = MIHM.SR_INSTANCE_ID (+)
4354: AND sa.ORGANIZATION_ID = MIHM.ORGANIZATION_ID (+)
4355: AND decode(MIHM.level_id (+),-1,1,2) = decode(MSC_AATP_PVT.G_HIERARCHY_PROFILE,1,1,2)
4356: AND TRUNC(sa.SUPPLY_DATE) >= MIHM.effective_date (+)
4357: AND TRUNC(sa.SUPPLY_DATE) <= MIHM.disable_date (+)
4358: AND MIHM.demand_class (+) = p_demand_class
4359: )

Line 4504: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,

4500: l_null_num col21,
4501: AD.PARENT_DEMAND_ID col22,
4502: l_null_num col23,
4503: -1* AD.ALLOCATED_QUANTITY *
4504: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,
4505: 1, decode(AD.Original_Origination_Type,
4506: 6, decode(AD.SOURCE_ORGANIZATION_ID,
4507: NULL, DECODE(AD.DEMAND_CLASS, null, null,
4508: DECODE(p_demand_class, '-1',

Line 4666: DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,

4662: p_family_id)),
4663: p_org_id,
4664: p_instance_id,
4665: AD.Original_Origination_Type,
4666: DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,
4667: 1, decode(AD.Original_Origination_Type,
4668: 6, decode(AD.SOURCE_ORGANIZATION_ID,
4669: NULL, DECODE(AD.DEMAND_CLASS, null, null,
4670: DECODE(p_demand_class, '-1',

Line 4829: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,

4825: 1)),
4826: AD.Pf_Display_Flag),
4827: -1* NVL(AD.Demand_Quantity, AD.ALLOCATED_QUANTITY),
4828: -1* NVL(AD.Demand_Quantity, AD.ALLOCATED_QUANTITY) *
4829: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,
4830: 1, decode(AD.Original_Origination_Type,
4831: 6, decode(AD.SOURCE_ORGANIZATION_ID,
4832: NULL, DECODE(AD.DEMAND_CLASS, null, null,
4833: DECODE(p_demand_class, '-1',

Line 4989: DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,

4985: p_family_id)),
4986: p_org_id,
4987: p_instance_id,
4988: AD.Original_Origination_Type,
4989: DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,
4990: 1, decode(AD.Original_Origination_Type,
4991: 6, decode(AD.SOURCE_ORGANIZATION_ID,
4992: NULL, DECODE(AD.DEMAND_CLASS, null, null,
4993: DECODE(p_demand_class, '-1',

Line 5196: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,

5192: l_null_num col21,
5193: CSA.PARENT_TRANSACTION_ID col22,
5194: l_null_num col23,
5195: CSA.ALLOCATED_QUANTITY*
5196: DECODE(DECODE(MSC_AATP_PVT.G_HIERARCHY_PROFILE,
5197: 1, DECODE(CSA.DEMAND_CLASS, null, null,
5198: DECODE(p_demand_class, '-1',
5199: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
5200: null,

Line 5331: AND decode(MIHM.level_id (+),-1,1,2) = decode(MSC_AATP_PVT.G_HIERARCHY_PROFILE,1,1,2)

5327: 'N', p_family_id,
5328: CSA.INVENTORY_ITEM_ID) = MIHM.INVENTORY_ITEM_ID(+)
5329: AND CSA.SR_INSTANCE_ID = MIHM.SR_INSTANCE_ID (+)
5330: AND CSA.ORGANIZATION_ID = MIHM.ORGANIZATION_ID (+)
5331: AND decode(MIHM.level_id (+),-1,1,2) = decode(MSC_AATP_PVT.G_HIERARCHY_PROFILE,1,1,2)
5332: AND TRUNC(CSA.SUPPLY_DATE) >= MIHM.effective_date (+)
5333: AND TRUNC(CSA.SUPPLY_DATE) <= MIHM.disable_date (+)
5334: AND MIHM.demand_class (+) = p_demand_class
5335: )