APPS.MSC_ATP_ALLOC dependencies on MSC_ITEM_HIERARCHY_MV

Line 564: FROM msc_item_hierarchy_mv mv

560: END IF;
561:
562: INSERT INTO MSC_ALLOC_TEMP(DEMAND_CLASS)
563: SELECT mv.demand_class
564: FROM msc_item_hierarchy_mv mv
565: WHERE mv.inventory_item_id = l_item_to_use
566: AND mv.organization_id = p_organization_id
567: AND mv.sr_instance_id = p_instance_id
568: AND p_request_date BETWEEN effective_date AND disable_date

Line 996: FROM msc_item_hierarchy_mv mv

992: If no demand class found on request date, dont proceed any further*/
993:
994: INSERT INTO MSC_ALLOC_TEMP(DEMAND_CLASS, PRIORITY, ALLOCATION_PERCENT)
995: SELECT mv.demand_class, mv.priority, mv.allocation_percent
996: FROM msc_item_hierarchy_mv mv
997: WHERE mv.inventory_item_id = l_item_to_use
998: AND mv.organization_id = p_organization_id
999: AND mv.sr_instance_id = p_instance_id
1000: AND p_request_date BETWEEN effective_date AND disable_date

Line 1991: FROM msc_item_hierarchy_mv A, msc_item_hierarchy_mv B,

1987: LEVEL_2_DEMAND_CLASS, LEVEL_1_DEMAND_CLASS, PARTNER_ID, PARTNER_SITE_ID,
1988: LEVEL_3_DEMAND_CLASS_PRIORITY, ALLOCATION_PERCENT, CUSTOMER_NAME, CUSTOMER_SITE_NAME)
1989: SELECT A.demand_class, B.demand_class, A.class, A.partner_id,
1990: A.partner_site_id, A.priority, A.allocation_percent, mtp.partner_name, mtps.location
1991: FROM msc_item_hierarchy_mv A, msc_item_hierarchy_mv B,
1992: msc_trading_partners mtp, msc_trading_partner_sites mtps
1993: WHERE A.inventory_item_id = l_item_to_use
1994: AND A.organization_id = p_organization_id
1995: AND A.sr_instance_id = p_instance_id

Line 3614: FROM MSC_ITEM_HIERARCHY_MV mv

3610: IF (p_dest_inv_item_id <> p_dest_family_item_id) and (G_ATF_Date is not null) THEN
3611: UPDATE MRP_ATP_DETAILS_TEMP madt
3612: SET (Actual_Allocation_Percent, Allocation_Percent)=
3613: (SELECT mv.allocation_percent, mv.level_alloc_percent
3614: FROM MSC_ITEM_HIERARCHY_MV mv
3615: WHERE mv.Demand_Class = madt.Demand_Class
3616: AND mv.Organization_Id = p_organization_id
3617: AND mv.Sr_Instance_Id = p_instance_id
3618: AND madt.Period_Start_Date between mv.Effective_Date and mv.Disable_Date

Line 3634: FROM MSC_ITEM_HIERARCHY_MV mv

3630: --rajjain 02/13/2003 Bug 2795636
3631: --SET (Allocation_Percent, Actual_Allocation_Percent)=
3632: SET (Actual_Allocation_Percent, Allocation_Percent)=
3633: (SELECT mv.allocation_percent, mv.level_alloc_percent
3634: FROM MSC_ITEM_HIERARCHY_MV mv
3635: WHERE mv.Demand_Class = madt.Demand_Class
3636: AND mv.Organization_Id = p_organization_id
3637: AND mv.Sr_Instance_Id = p_instance_id
3638: AND madt.Period_Start_Date between mv.Effective_Date and mv.Disable_Date

Line 4281: FROM MSC_ITEM_HIERARCHY_MV mv

4277: --rajjain 02/13/2003 Bug 2795636
4278: --SET (Allocation_Percent, Actual_Allocation_Percent)=
4279: SET (Actual_Allocation_Percent, Allocation_Percent)=
4280: (SELECT mv.allocation_percent, mv.level_alloc_percent
4281: FROM MSC_ITEM_HIERARCHY_MV mv
4282: WHERE mv.Class = madt.Class
4283: AND nvl(mv.Partner_Id, -23453) = nvl(madt.Customer_Id, -23453)
4284: AND nvl(mv.Partner_Site_Id, -23453) = nvl(madt.Customer_Site_Id, -23453)
4285: AND mv.Organization_Id = p_organization_id

Line 4303: FROM MSC_ITEM_HIERARCHY_MV mv

4299: --rajjain 02/13/2003 Bug 2795636
4300: --SET (Allocation_Percent, Actual_Allocation_Percent)=
4301: SET (Actual_Allocation_Percent, Allocation_Percent)=
4302: (SELECT mv.allocation_percent, mv.level_alloc_percent
4303: FROM MSC_ITEM_HIERARCHY_MV mv
4304: WHERE mv.Class = madt.Class
4305: AND nvl(mv.Partner_Id, -23453) = nvl(madt.Customer_Id, -23453)
4306: AND nvl(mv.Partner_Site_Id, -23453) = nvl(madt.Customer_Site_Id, -23453)
4307: AND mv.Organization_Id = p_organization_id