DBA Data[Home] [Help]

APPS.MTL_ABC_COMPILE_PKG dependencies on MRP_FORECAST_DATES

Line 34: MRP_FORECAST_DATES F,

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
38: AND D2.ORGANIZATION_ID = x_organization_id

Line 71: BOM_CAL_WEEK_START_DATES W1, MRP_FORECAST_DATES F,

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

Line 127: BOM_PERIOD_START_DATES W1, MRP_FORECAST_DATES F,

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