APPS.MSC_ATP_PEG dependencies on MSC_ATP_PEG_TEMP

Line 1912: FROM msc_atp_peg_temp mapt, msc_item_hierarchy_mv mv

1908: mapt.relief_quantity ,
1909: mapt.pegging_id, mapt.prev_pegging_id, mapt.end_pegging_id,
1910: :p_user_id, :p_sysdate, :p_user_id, :p_sysdate,
1911: mv.partner_id, mv.partner_site_id customer_site_id
1912: FROM msc_atp_peg_temp mapt, msc_item_hierarchy_mv mv
1913: WHERE mapt.plan_id = :p_plan_id
1914: AND mapt.relief_type = 3
1915: AND mapt.inventory_item_id = mv.inventory_item_id(+)
1916: AND mapt.organization_id = mv.organization_id (+)

Line 1966: FROM msc_atp_peg_temp mapt, msc_item_hierarchy_mv mv

1962: mapt.relief_quantity ,
1963: mapt.pegging_id, mapt.prev_pegging_id, mapt.end_pegging_id,
1964: :p_user_id, :p_sysdate, :p_user_id, :p_sysdate,
1965: mv.partner_id, mv.partner_site_id customer_site_id
1966: FROM msc_atp_peg_temp mapt, msc_item_hierarchy_mv mv
1967: WHERE mapt.plan_id = :p_plan_id
1968: AND mapt.relief_type = 2
1969: AND mapt.inventory_item_id = mv.inventory_item_id(+)
1970: AND mapt.organization_id = mv.organization_id (+)

Line 2979: l_global_temp_table := 'MSC_ATP_PEG_TEMP';

2975: -- Second set the table names.
2976:
2977: -- Bug 3344102
2978: -- Set the Global temporary table name.
2979: l_global_temp_table := 'MSC_ATP_PEG_TEMP';
2980: -- End Bug 3344102
2981:
2982: FOR i in 1..atp_simple_peg_tab.count LOOP
2983:

Line 4323: msc_atp_peg_temp

4319: creation_date,
4320: last_updated_by,
4321: last_update_date
4322: FROM
4323: msc_atp_peg_temp
4324: WHERE plan_id = :p_plan_id
4325: AND end_demand_id = :l_end_demand_id
4326: AND relief_type in (2, 3) ';
4327:

Line 4347: -- insert into MSC_ATP_PEG_TEMP_NEW select * from MSC_ATP_PEG_TEMP; --MSC_ATP_PEG_TEMP

4343: -- End Bug 3344102 Secod insert the data into the main table.
4344: */
4345:
4346: END LOOP; -- End config_items loop
4347: -- insert into MSC_ATP_PEG_TEMP_NEW select * from MSC_ATP_PEG_TEMP; --MSC_ATP_PEG_TEMP
4348: -- End Bug 3344102 Call Creation of ATP Pegging Data for Allocated ATP case.
4349: IF ((G_ALLOC_ATP = 'Y' AND G_CLASS_HRCHY = 1 AND G_ALLOC_METHOD = 1)
4350: AND l_time_phased_atp = 'N') THEN
4351: Create_Pre_Allocation_Reliefs ( p_plan_id,

Line 6597: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,

6593: mapt.pegging_id, mapt.prev_pegging_id, mapt.end_pegging_id, mapt.end_demand_id,
6594: mapt.created_by, mapt.creation_date, mapt.last_updated_by, mapt.last_update_date,
6595: mapt.inventory_item_id, mapt.transaction_date,
6596: alocd.customer_id, alocd.ship_to_site_id
6597: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,
6598: msc_system_items msi
6599: WHERE mapt.reference_item_id = p_reference_item_id
6600: AND mapt.plan_id = p_plan_id
6601: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)

Line 6642: FROM msc_atp_peg_temp mapt

6638: relief_type, relief_quantity, daily_relief_qty,
6639: pegging_id, prev_pegging_id, end_pegging_id, end_demand_id,
6640: created_by, creation_date, last_updated_by, last_update_date,
6641: customer_id, customer_site_id
6642: FROM msc_atp_peg_temp mapt
6643: WHERE mapt.reference_item_id = p_reference_item_id
6644: AND mapt.plan_id = p_plan_id
6645: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)
6646: --AND mapt.demand_source_type = p_demand_source_type

Line 6733: l_insert_temp_table := 'MSC_ATP_PEG_TEMP';

6729: x_return_status := FND_API.G_RET_STS_SUCCESS;
6730:
6731: -- CTO_PF_PRJ_2 Impacts
6732: IF (MSC_ATP_PVT.G_CTO_PF_ATP = 'Y') THEN
6733: l_insert_temp_table := 'MSC_ATP_PEG_TEMP';
6734: ELSE
6735: l_insert_temp_table := 'MSC_ATP_PEGGING';
6736: END IF;
6737: