APPS.MSC_ATP_ALLOC dependencies on MSC_ALLOC_HIERARCHY_TEMP

Line 1983: 3. Store all these in 8i temp table msc_alloc_hierarchy_temp.

1979: END IF;
1980:
1981: /* 1. Find all the level 3 nodes for given item/inst/org/on p_request_date
1982: 2. For each level 3 record, find parent demand class and grandparent demand class
1983: 3. Store all these in 8i temp table msc_alloc_hierarchy_temp.
1984: 4. Also store the partner_id, partner_site_id and priority of level 3 demand classes*/
1985:
1986: INSERT INTO MSC_ALLOC_HIERARCHY_TEMP( LEVEL_3_DEMAND_CLASS,
1987: LEVEL_2_DEMAND_CLASS, LEVEL_1_DEMAND_CLASS, PARTNER_ID, PARTNER_SITE_ID,

Line 1986: INSERT INTO MSC_ALLOC_HIERARCHY_TEMP( LEVEL_3_DEMAND_CLASS,

1982: 2. For each level 3 record, find parent demand class and grandparent demand class
1983: 3. Store all these in 8i temp table msc_alloc_hierarchy_temp.
1984: 4. Also store the partner_id, partner_site_id and priority of level 3 demand classes*/
1985:
1986: INSERT INTO MSC_ALLOC_HIERARCHY_TEMP( LEVEL_3_DEMAND_CLASS,
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

Line 2284: MSC_ALLOC_HIERARCHY_TEMP TEMP,

2280: FROM
2281: MSC_DEMANDS D,
2282: -- Bug 3823042
2283: --MSC_CALENDAR_DATES C,
2284: MSC_ALLOC_HIERARCHY_TEMP TEMP,
2285: MSC_TRADING_PARTNERS MTP,--bug3263368
2286: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2287:
2288: WHERE

Line 2408: MSC_ALLOC_HIERARCHY_TEMP TEMP

2404: FROM
2405: -- Bug 3823042
2406: --MSC_CALENDAR_DATES C,
2407: MSC_SUPPLIES S,
2408: MSC_ALLOC_HIERARCHY_TEMP TEMP
2409: WHERE
2410: S.PLAN_ID = p_plan_id
2411: AND S.SR_INSTANCE_ID = p_instance_id
2412: AND S.INVENTORY_ITEM_ID = l_item_to_use

Line 2594: MSC_ALLOC_HIERARCHY_TEMP TEMP,

2590: D.REQUEST_DATE,D.REQUEST_SHIP_DATE) col29 --bug3263368
2591: FROM
2592: MSC_DEMANDS D,
2593: MSC_CALENDAR_DATES C,
2594: MSC_ALLOC_HIERARCHY_TEMP TEMP,
2595: MSC_TRADING_PARTNERS MTP,--bug3263368
2596: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2597:
2598: WHERE

Line 2710: MSC_ALLOC_HIERARCHY_TEMP TEMP

2706: l_null_date COL29 --bug3263368 ORIG_REQUEST_DATE -- Bug 3875786 - null removed
2707: FROM
2708: MSC_CALENDAR_DATES C,
2709: MSC_SUPPLIES S,
2710: MSC_ALLOC_HIERARCHY_TEMP TEMP
2711: WHERE
2712: S.PLAN_ID = p_plan_id
2713: AND S.SR_INSTANCE_ID = p_instance_id
2714: AND S.INVENTORY_ITEM_ID = l_item_to_use -- Bug 3823042

Line 2745: FROM MSC_ALLOC_HIERARCHY_TEMP;

2741: --x_return_status := FND_API.G_RET_STS_ERROR;
2742: --return;
2743: SELECT LEVEL_3_DEMAND_CLASS, LEVEL_1_DEMAND_CLASS, PARTNER_ID, PARTNER_SITE_ID
2744: BULK COLLECT INTO l_dc_list_tab, l_class_tab, l_customer_id_tab, l_customer_site_id_tab
2745: FROM MSC_ALLOC_HIERARCHY_TEMP;
2746:
2747: l_dc_list_tab.Extend();
2748: l_class_tab.Extend();
2749: l_customer_id_tab.Extend();