APPS.MTL_ABC_COMPILE_PKG dependencies on MRP_FORECAST_DESIGNATORS

Line 32: MRP_FORECAST_DESIGNATORS D1,

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
36: WHERE D2.FORECAST_DESIGNATOR = x_forc_name

Line 33: MRP_FORECAST_DESIGNATORS D2,

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
36: WHERE D2.FORECAST_DESIGNATOR = x_forc_name
37: AND D1.ORGANIZATION_ID = x_organization_id

Line 72: MRP_FORECAST_DESIGNATORS D1, MRP_FORECAST_DESIGNATORS D2,

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
75: AND D1.ORGANIZATION_ID = x_organization_id
76: AND D2.ORGANIZATION_ID = x_organization_id

Line 128: MRP_FORECAST_DESIGNATORS D1, MRP_FORECAST_DESIGNATORS D2,

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
131: AND D1.ORGANIZATION_ID = x_organization_id
132: AND D2.ORGANIZATION_ID = x_organization_id