APPS.MTL_ABC_COMPILE_PKG dependencies on MTL_ABC_COMPILES

Line 35: MTL_ABC_COMPILES ABC

31: BOM_CALENDAR_DATES C1,
32: MRP_FORECAST_DESIGNATORS D1,
33: MRP_FORECAST_DESIGNATORS D2,
34: MRP_FORECAST_DATES F,
35: MTL_ABC_COMPILES ABC
36: WHERE D2.FORECAST_DESIGNATOR = x_forc_name
37: AND D1.ORGANIZATION_ID = x_organization_id
38: AND D2.ORGANIZATION_ID = x_organization_id
39: AND D1.FORECAST_SET = NVL(D2.FORECAST_SET, x_forc_name)

Line 73: MTL_ABC_COMPILES ABC

69: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,
70: BOM_CALENDAR_DATES C3,
71: BOM_CAL_WEEK_START_DATES W1, MRP_FORECAST_DATES F,
72: MRP_FORECAST_DESIGNATORS D1, MRP_FORECAST_DESIGNATORS D2,
73: MTL_ABC_COMPILES ABC
74: WHERE D2.FORECAST_DESIGNATOR = x_forc_name
75: AND D1.ORGANIZATION_ID = x_organization_id
76: AND D2.ORGANIZATION_ID = x_organization_id
77: AND D1.FORECAST_SET = NVL(D2.FORECAST_SET, x_forc_name)

Line 129: MTL_ABC_COMPILES ABC

125: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,
126: BOM_CALENDAR_DATES C3,
127: BOM_PERIOD_START_DATES W1, MRP_FORECAST_DATES F,
128: MRP_FORECAST_DESIGNATORS D1, MRP_FORECAST_DESIGNATORS D2,
129: MTL_ABC_COMPILES ABC
130: WHERE D2.FORECAST_DESIGNATOR = x_forc_name
131: AND D1.ORGANIZATION_ID = x_organization_id
132: AND D2.ORGANIZATION_ID = x_organization_id
133: AND D1.FORECAST_SET = NVL(D2.FORECAST_SET, x_forc_name)

Line 178: UPDATE MTL_ABC_COMPILES

174: AND C1.CALENDAR_DATE < C2.CALENDAR_DATE)
175: group by F.INVENTORY_ITEM_ID;
176:
177: FORALL i IN l_item_id.FIRST .. l_item_id.LAST
178: UPDATE MTL_ABC_COMPILES
179: SET COMPILE_QUANTITY = COMPILE_QUANTITY + l_qty_demand_total(i),
180: COMPILE_VALUE = COMPILE_VALUE + l_value_demand_total(i)
181: WHERE ORGANIZATION_ID = x_organization_id
182: AND inventory_item_id = l_item_id(i)

Line 239: FROM mtl_abc_compiles

235: CURSOR cur_get_abc_compiles IS
236: SELECT organization_id
237: , inventory_item_id
238: , compile_id
239: FROM mtl_abc_compiles
240: WHERE compile_id = p_compile_id
241: FOR UPDATE;
242:
243: BEGIN

Line 289: UPDATE mtl_abc_compiles

285: IF l_result_code <> 1 THEN
286: l_item_cost := 0;
287: END IF;
288:
289: UPDATE mtl_abc_compiles
290: SET compile_value = compile_quantity * l_item_cost
291: WHERE CURRENT OF cur_get_abc_compiles;
292:
293: END LOOP;