DBA Data[Home] [Help]

APPS.MTL_SAFETY_STOCKS_PKG dependencies on BOM_CAL_WEEK_START_DATES

Line 388: BOM_CAL_WEEK_START_DATES W1, MRP_FORECAST_DATES F,

384: ROUND(SUM(NVL(F.FORECAST_MAD, 0)/(C2.NEXT_SEQ_NUM - -- 6797274 changes
385: C3.NEXT_SEQ_NUM)) * srv_factor, 5)
386: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,
387: BOM_CALENDAR_DATES C3,
388: BOM_CAL_WEEK_START_DATES W1, MRP_FORECAST_DATES F,
389: MRP_FORECAST_DESIGNATORS D1
390: WHERE D1.ORGANIZATION_ID = org_id
391: AND D1.FORECAST_DESIGNATOR = forc_name
392: AND F.ORGANIZATION_ID = org_id

Line 476: BOM_CAL_WEEK_START_DATES W1, MRP_FORECAST_DATES F,

472: ROUND(SUM(ORIGINAL_FORECAST_QUANTITY/
473: (C2.NEXT_SEQ_NUM - C3.NEXT_SEQ_NUM))* ss_percent/100 ,5)
474: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,
475: BOM_CALENDAR_DATES C3,
476: BOM_CAL_WEEK_START_DATES W1, MRP_FORECAST_DATES F,
477: MRP_FORECAST_DESIGNATORS D1
478: WHERE D1.ORGANIZATION_ID = org_id
479: AND D1.FORECAST_DESIGNATOR = forc_name
480: AND F.ORGANIZATION_ID = org_id