APPS.MTL_ABC_COMPILE_PKG dependencies on BOM_CALENDAR_DATES

Line 31: BOM_CALENDAR_DATES C1,

27: F.PROJECT_ID,
28: x_org_cost_group_id))
29: BULK COLLECT INTO l_item_id,l_qty_demand_total,l_value_demand_total
30: FROM
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

Line 69: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,

65: MTL_ABC_COMPILE_PKG.get_item_cost(F.ORGANIZATION_ID,
66: F.INVENTORY_ITEM_ID,
67: F.PROJECT_ID,
68: x_org_cost_group_id))
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

Line 70: BOM_CALENDAR_DATES C3,

66: F.INVENTORY_ITEM_ID,
67: F.PROJECT_ID,
68: x_org_cost_group_id))
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

Line 125: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,

121: MTL_ABC_COMPILE_PKG.get_item_cost(F.ORGANIZATION_ID,
122: F.INVENTORY_ITEM_ID,
123: F.PROJECT_ID,
124: x_org_cost_group_id))
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

Line 126: BOM_CALENDAR_DATES C3,

122: F.INVENTORY_ITEM_ID,
123: F.PROJECT_ID,
124: x_org_cost_group_id))
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