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_ITEM_HIERARCHY_MV

Line 3362: FROM msc_item_hierarchy_mv

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
3363: WHERE inventory_item_id = p_member_id
3364: AND organization_id = p_org_id
3365: AND sr_instance_id = p_instance_id
3366: AND p_atf_date BETWEEN effective_date AND disable_date

Line 3386: FROM msc_item_hierarchy_mv

3382: ELSE
3383: BEGIN
3384: SELECT allocation_percent
3385: INTO l_alloc_percent
3386: FROM msc_item_hierarchy_mv
3387: WHERE inventory_item_id = p_member_id
3388: AND organization_id = p_org_id
3389: AND sr_instance_id = p_instance_id
3390: AND p_atf_date BETWEEN effective_date AND disable_date

Line 3866: FROM MSC_ALLOC_SUPPLIES SA, MSC_ITEM_HIERARCHY_MV MIHM --4365873

3862: p_demand_class,
3863: TRUNC(SA.SUPPLY_DATE)),*/
3864: NULL, 1,
3865: 0)) SD_QTY
3866: FROM MSC_ALLOC_SUPPLIES SA, MSC_ITEM_HIERARCHY_MV MIHM --4365873
3867: WHERE SA.PLAN_ID = p_plan_id
3868: AND SA.SR_INSTANCE_ID = p_instance_id
3869: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
3870: AND SA.ORGANIZATION_ID = p_org_id

Line 4336: FROM MSC_ALLOC_SUPPLIES SA,MSC_ITEM_HIERARCHY_MV MIHM

4332: p_demand_class,
4333: TRUNC(sa.SUPPLY_DATE)),*/
4334: NULL, 1,
4335: 0)) SD_QTY
4336: FROM MSC_ALLOC_SUPPLIES SA,MSC_ITEM_HIERARCHY_MV MIHM
4337: WHERE SA.PLAN_ID = p_plan_id
4338: AND SA.SR_INSTANCE_ID = p_instance_id
4339: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
4340: AND SA.ORGANIZATION_ID = p_org_id

Line 5322: MSC_ITEM_HIERARCHY_MV MIHM

5318: AND SA.PLAN_ID = I.PLAN_ID
5319: AND SA.SR_INSTANCE_ID = I.SR_INSTANCE_ID
5320: AND SA.ORIGINAL_ITEM_ID = I.INVENTORY_ITEM_ID
5321: AND SA.ORGANIZATION_ID = I.ORGANIZATION_ID) CSA,
5322: MSC_ITEM_HIERARCHY_MV MIHM
5323: WHERE
5324: --4365873
5325: --5220274 if the rule is assigned to family only then use family id.
5326: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,

Line 10334: msc_item_hierarchy_mv mv

10330: AND mat.pegging_id = peg.end_pegging_id
10331: AND s.sr_instance_id = peg.sr_instance_id
10332: AND s.plan_id = peg.plan_id
10333: AND s.transaction_id = peg.transaction_id) pegging_v,
10334: msc_item_hierarchy_mv mv
10335: WHERE pegging_v.product_family_id = mv.inventory_item_id(+)
10336: AND pegging_v.organization_id = mv.organization_id (+)
10337: AND pegging_v.sr_instance_id = mv.sr_instance_id (+)
10338: AND pegging_v.demand_date >= mv.effective_date (+)

Line 10701: msc_item_hierarchy_mv mv

10697: AND peg.plan_id = s.plan_id
10698: AND peg.transaction_id = s.transaction_id
10699: AND peg.sr_instance_id = s.sr_instance_id
10700: AND mat.pegging_id = peg.end_pegging_id) pegging_v,
10701: msc_item_hierarchy_mv mv
10702: WHERE pegging_v.product_family_id = mv.inventory_item_id(+)
10703: AND pegging_v.organization_id = mv.organization_id (+)
10704: AND pegging_v.sr_instance_id = mv.sr_instance_id (+)
10705: AND pegging_v.supply_date >= mv.effective_date (+)

Line 11009: msc_item_hierarchy_mv mv

11005: AND msi.plan_id = s.plan_id
11006: AND msi.inventory_item_id = s.inventory_item_id
11007: AND msi.sr_instance_id = s.sr_instance_id
11008: AND msi.organization_id = s.organization_id) pegging_v,
11009: msc_item_hierarchy_mv mv
11010: WHERE pegging_v.product_family_id = mv.inventory_item_id(+)
11011: AND pegging_v.organization_id = mv.organization_id (+)
11012: AND pegging_v.sr_instance_id = mv.sr_instance_id (+)
11013: AND pegging_v.demand_date >= mv.effective_date (+)

Line 11621: msc_item_hierarchy_mv mv

11617: AND msi.inventory_item_id = s.inventory_item_id
11618: AND msi.sr_instance_id = s.sr_instance_id
11619: AND msi.organization_id = s.organization_id
11620: ) pegging_v,
11621: msc_item_hierarchy_mv mv
11622: WHERE pegging_v.product_family_id = mv.inventory_item_id(+)
11623: AND pegging_v.organization_id = mv.organization_id (+)
11624: AND pegging_v.sr_instance_id = mv.sr_instance_id (+)
11625: AND pegging_v.demand_date >= mv.effective_date (+)

Line 11801: msc_item_hierarchy_mv mv

11797: AND msi.sr_instance_id = s.sr_instance_id
11798: AND msi.plan_id = s.plan_id
11799: AND msi.organization_id = s.organization_id
11800: AND msi.inventory_item_id = s.inventory_item_id) pegging_v,
11801: msc_item_hierarchy_mv mv
11802: WHERE pegging_v.product_family_id = mv.inventory_item_id(+)
11803: AND pegging_v.organization_id = mv.organization_id (+)
11804: AND pegging_v.sr_instance_id = mv.sr_instance_id (+)
11805: AND pegging_v.supply_date >= mv.effective_date (+)

Line 12117: msc_item_hierarchy_mv mv

12113: AND msi.plan_id = s.plan_id
12114: AND msi.organization_id = s.organization_id
12115: AND msi.inventory_item_id = s.inventory_item_id
12116: ) pegging_v,
12117: msc_item_hierarchy_mv mv
12118: WHERE pegging_v.product_family_id = mv.inventory_item_id(+)
12119: AND pegging_v.organization_id = mv.organization_id (+)
12120: AND pegging_v.sr_instance_id = mv.sr_instance_id (+)
12121: AND pegging_v.supply_date >= mv.effective_date (+)

Line 12390: msc_item_hierarchy_mv mv

12386:
12387: AND s.sr_instance_id = mapt.sr_instance_id
12388: AND s.plan_id = mapt.plan_id
12389: AND s.transaction_id = mapt.supply_id) peg_v,
12390: msc_item_hierarchy_mv mv
12391: WHERE
12392: decode(peg_v.atf_date,
12393: NULL,peg_v.inventory_item_id,
12394: peg_v.product_family_id) = mv.inventory_item_id(+)

Line 12484: FROM msc_atp_peg_temp mapt, msc_item_hierarchy_mv mv

12480: :p_sysdate,
12481: mv.partner_id,
12482: mv.partner_site_id customer_site_id,
12483: mapt.offset_type
12484: FROM msc_atp_peg_temp mapt, msc_item_hierarchy_mv mv
12485: WHERE mapt.plan_id = :p_plan_id
12486: AND mapt.relief_type = 2
12487: AND mapt.inventory_item_id = mv.inventory_item_id(+)
12488: AND mapt.organization_id = mv.organization_id (+)