[Home] [Help]
6037: -- initialize API return status to success
6038: x_return_status := FND_API.G_RET_STS_SUCCESS;
6039:
6040: IF p_type = Demand_Priority THEN
6041: INSERT INTO MRP_ATP_DETAILS_TEMP
6042: (session_id, atp_level, inventory_item_id, organization_id, identifier1, identifier3,
6043: supply_demand_type, supply_demand_date, supply_demand_quantity, supply_demand_source_type,
6044: allocated_quantity, record_type, scenario_id, disposition_name, demand_class, char1,
6045: uom_code, plan_id, inventory_item_name, organization_code,
6183: AND SA.CUSTOMER_ID = MTP.PARTNER_ID(+) --bug3684383
6184: );
6185:
6186: ELSIF p_type = User_Defined_DC THEN
6187: INSERT INTO MRP_ATP_DETAILS_TEMP
6188: (session_id, atp_level, inventory_item_id, organization_id, identifier1, identifier3,
6189: supply_demand_type, supply_demand_date, supply_demand_quantity, supply_demand_source_type,
6190: allocated_quantity, record_type, scenario_id, disposition_name, demand_class, uom_code,
6191: inventory_item_name, organization_code, identifier2, identifier4, request_item_id,
6782: TRUNC(SA.SUPPLY_DATE))
6783: AND TRUNC(SA.SUPPLY_DATE) < NVL(p_itf, TRUNC(SA.SUPPLY_DATE) + 1)
6784: );
6785: ELSIF p_type = User_Defined_CC THEN
6786: INSERT INTO MRP_ATP_DETAILS_TEMP
6787: (session_id, atp_level, inventory_item_id, organization_id, identifier1, identifier3,
6788: supply_demand_type, supply_demand_date, supply_demand_quantity, supply_demand_source_type,
6789: allocated_quantity, record_type, scenario_id, disposition_name, demand_class, class, customer_id,
6790: customer_site_id, uom_code, inventory_item_name, organization_code, identifier2, identifier4,
7344: FROM msc_alloc_demands
7345: WHERE (demand_class, parent_demand_id) in
7346: (SELECT demand_class,
7347: identifier3
7348: FROM mrp_atp_details_temp
7349: WHERE session_id = p_session_id
7350: AND supply_demand_type = 1
7351: AND record_type = 2)
7352: AND plan_id = p_plan_id
7354: demand_class,
7355: parent_demand_id
7356: );
7357:
7358: /* Now update original demand qtys in mrp_atp_details_temp table*/
7359: UPDATE mrp_atp_details_temp madt
7360: SET madt.original_demand_quantity =
7361: (select -1*mat.supply_demand_quantity
7362: from msc_alloc_temp mat
7355: parent_demand_id
7356: );
7357:
7358: /* Now update original demand qtys in mrp_atp_details_temp table*/
7359: UPDATE mrp_atp_details_temp madt
7360: SET madt.original_demand_quantity =
7361: (select -1*mat.supply_demand_quantity
7362: from msc_alloc_temp mat
7363: where mat.demand_class = madt.demand_class
8114: END Get_Unalloc_Data_From_Sd_Temp;
8115:
8116: /*--Get_Period_From_Details_Temp--------------------------------------------
8117: | o Called from Compute_Allocation_Details in time phased pf scenarios.
8118: | o This function returns the period data from mrp_atp_details_temp.
8119: +-------------------------------------------------------------------------*/
8120: PROCEDURE Get_Period_From_Details_Temp(
8121: p_type IN INTEGER,
8122: p_inv_item_id IN NUMBER,
8198: 0) col6, -- Total Demand
8199: DECODE(SUPPLY_DEMAND_TYPE, 1, ALLOCATED_QUANTITY, 0) col7, -- Total Bucketed Demand
8200: ALLOCATED_QUANTITY col8 -- Period Quantity
8201: FROM
8202: MRP_ATP_DETAILS_TEMP
8203: WHERE
8204: SESSION_ID = p_session_id
8205: AND RECORD_TYPE = p_record_type
8206:
8214: ORIGINAL_DEMAND_QUANTITY col6, -- Total Demand
8215: 0 col7, -- Total Bucketed Demand
8216: 0 col8 -- Period Quantity
8217: FROM
8218: MRP_ATP_DETAILS_TEMP
8219: WHERE
8220: SESSION_ID = p_session_id
8221: AND RECORD_TYPE = p_record_type
8222: AND SUPPLY_DEMAND_TYPE = 1
8303: 0) col9, -- Unallocated Demand
8304: DECODE(SUPPLY_DEMAND_TYPE, 1, UNALLOCATED_QUANTITY, 0) col10, -- Unallocated Bucketed Demand
8305: UNALLOCATED_QUANTITY col11, -- Unallocated Net
8306: IDENTIFIER4 col12
8307: FROM MRP_ATP_DETAILS_TEMP
8308: WHERE SESSION_ID = p_session_id
8309: AND RECORD_TYPE = p_record_type
8310:
8311: UNION ALL
8322: 0 col10,
8323: 0 col11,
8324: IDENTIFIER4 col12
8325: FROM
8326: MRP_ATP_DETAILS_TEMP
8327: WHERE
8328: SESSION_ID = p_session_id
8329: AND RECORD_TYPE = p_record_type
8330: AND SUPPLY_DEMAND_TYPE = 1
8424: 0) col12, -- Unallocated Demand
8425: DECODE(SUPPLY_DEMAND_TYPE, 1, UNALLOCATED_QUANTITY, 0) col13, -- Unallocated Bucketed Demand
8426: UNALLOCATED_QUANTITY col14, -- Unallocated Net
8427: CUSTOMER_SITE_ID col15
8428: FROM MRP_ATP_DETAILS_TEMP
8429: WHERE SESSION_ID = p_session_id
8430: AND RECORD_TYPE = p_record_type
8431:
8432: UNION ALL
8446: 0 col13,
8447: 0 col14,
8448: CUSTOMER_SITE_ID col15
8449: FROM
8450: MRP_ATP_DETAILS_TEMP
8451: WHERE
8452: SESSION_ID = p_session_id
8453: AND RECORD_TYPE = p_record_type
8454: AND SUPPLY_DEMAND_TYPE = 1