APPS.MRP_EXPL_STD_MANDATORY dependencies on MRP_DERIVED_SO_DEMANDS

Line 127: does we will set the primary qty to 0 in mrp_derived_so_demands -- Removed this code*/

123: -(NVL(l_smc_table.atp_lead_time(1),0)));
124:
125:
126: /* Bug 2550996 - Check if component demand exists for component in wip...if it
127: does we will set the primary qty to 0 in mrp_derived_so_demands -- Removed this code*/
128:
129: /*---------------------------------------------------------------------------------------+
130: | If the job for the config Item exists, get that the value of wip_job_demand existsr |
131: | from the arguments passed |

Line 139: INSERT INTO MRP_DERIVED_SO_DEMANDS

135: lv_wip_demand_exists_flag := p_wip_demand_exists;
136: END IF;
137:
138: FORALL i in l_smc_table.inventory_item_id.FIRST .. l_smc_table.inventory_item_id.LAST
139: INSERT INTO MRP_DERIVED_SO_DEMANDS
140: (INVENTORY_ITEM_ID,
141: ORGANIZATION_ID,
142: PRIMARY_UOM_QUANTITY,
143: RESERVATION_TYPE,

Line 272: lv_sql_stmt:= 'TRUNCATE TABLE '||lv_mrp_schema||'.MRP_DERIVED_SO_DEMANDS';

268: lv_bom_table:='bom_bill_of_materials';
269: END IF;
270:
271: BEGIN
272: lv_sql_stmt:= 'TRUNCATE TABLE '||lv_mrp_schema||'.MRP_DERIVED_SO_DEMANDS';
273: EXECUTE IMMEDIATE lv_sql_stmt;
274:
275: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Value of p_lrn is :'||p_lrn);
276:

Line 469: INSERT INTO MRP_DERIVED_SO_DEMANDS

465: -- This helps an user doing ATP on ATO Model/ Option Class.
466: -- The user should ensure that he runs the source MPS plan before
467: -- data collection.
468:
469: INSERT INTO MRP_DERIVED_SO_DEMANDS
470: (INVENTORY_ITEM_ID,
471: ORGANIZATION_ID,
472: PRIMARY_UOM_QUANTITY,
473: RESERVATION_TYPE,