[Home] [Help]
1910: mapt.relief_quantity ,
1911: mapt.pegging_id, mapt.prev_pegging_id, mapt.end_pegging_id,
1912: :p_user_id, :p_sysdate, :p_user_id, :p_sysdate,
1913: mv.partner_id, mv.partner_site_id customer_site_id,1
1914: FROM msc_atp_peg_temp mapt, msc_item_hierarchy_mv mv
1915: WHERE mapt.plan_id = :p_plan_id
1916: AND mapt.relief_type = 3
1917: AND mapt.inventory_item_id = mv.inventory_item_id(+)
1918: AND mapt.organization_id = mv.organization_id (+)
1964: mapt.relief_quantity ,
1965: mapt.pegging_id, mapt.prev_pegging_id, mapt.end_pegging_id,
1966: :p_user_id, :p_sysdate, :p_user_id, :p_sysdate,
1967: mv.partner_id, mv.partner_site_id customer_site_id,1
1968: FROM msc_atp_peg_temp mapt, msc_item_hierarchy_mv mv
1969: WHERE mapt.plan_id = :p_plan_id
1970: AND mapt.relief_type = 2
1971: AND mapt.inventory_item_id = mv.inventory_item_id(+)
1972: AND mapt.organization_id = mv.organization_id (+)
2977: -- Second set the table names.
2978:
2979: -- Bug 3344102
2980: -- Set the Global temporary table name.
2981: l_global_temp_table := 'MSC_ATP_PEG_TEMP';
2982: -- End Bug 3344102
2983:
2984: FOR i in 1..atp_simple_peg_tab.count LOOP
2985:
4321: creation_date,
4322: last_updated_by,
4323: last_update_date
4324: FROM
4325: msc_atp_peg_temp
4326: WHERE plan_id = :p_plan_id
4327: AND end_demand_id = :l_end_demand_id
4328: AND relief_type in (2, 3) ';
4329:
4345: -- End Bug 3344102 Secod insert the data into the main table.
4346: */
4347:
4348: END LOOP; -- End config_items loop
4349: -- insert into MSC_ATP_PEG_TEMP_NEW select * from MSC_ATP_PEG_TEMP; --MSC_ATP_PEG_TEMP
4350: -- End Bug 3344102 Call Creation of ATP Pegging Data for Allocated ATP case.
4351: IF ((G_ALLOC_ATP = 'Y' AND G_CLASS_HRCHY = 1 AND G_ALLOC_METHOD = 1)
4352: AND l_time_phased_atp = 'N') THEN
4353: Create_Pre_Allocation_Reliefs ( p_plan_id,
6614: DECODE(MSC_ATP_PVT.G_ALLOCATION_METHOD, 2, 2,
6615: decode(alloc.inventory_item_id, null, 2 , 1)
6616: )
6617: ) offset_type
6618: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,
6619: msc_system_items msi, msc_item_hierarchy_mv alloc
6620: WHERE mapt.reference_item_id = p_reference_item_id
6621: AND mapt.plan_id = p_plan_id
6622: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)
6666: mapt.pegging_id, mapt.prev_pegging_id, mapt.end_pegging_id, mapt.end_demand_id,
6667: mapt.created_by, mapt.creation_date, mapt.last_updated_by, mapt.last_update_date,
6668: mapt.inventory_item_id, mapt.transaction_date,
6669: alocd.customer_id, alocd.ship_to_site_id, 2
6670: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,
6671: msc_system_items msi
6672: WHERE mapt.reference_item_id = p_reference_item_id
6673: AND mapt.plan_id = p_plan_id
6674: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)
6713: relief_type, relief_quantity, daily_relief_qty,
6714: pegging_id, prev_pegging_id, end_pegging_id, end_demand_id,
6715: created_by, creation_date, last_updated_by, last_update_date,
6716: customer_id, customer_site_id, offset_type
6717: FROM msc_atp_peg_temp mapt
6718: WHERE mapt.reference_item_id = p_reference_item_id
6719: AND mapt.plan_id = p_plan_id
6720: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)
6721: --AND mapt.demand_source_type = p_demand_source_type
6805: x_return_status := FND_API.G_RET_STS_SUCCESS;
6806:
6807: -- CTO_PF_PRJ_2 Impacts
6808: IF (MSC_ATP_PVT.G_CTO_PF_ATP = 'Y') THEN
6809: l_insert_temp_table := 'MSC_ATP_PEG_TEMP';
6810: ELSE
6811: l_insert_temp_table := 'MSC_ATP_PEGGING';
6812: END IF;
6813: