DBA Data[Home] [Help]

APPS.MTL_SAFETY_STOCKS_PKG dependencies on BOM_PERIOD_START_DATES

Line 421: BOM_PERIOD_START_DATES W1, MRP_FORECAST_DATES F,

417: ROUND(SUM(NVL(F.FORECAST_MAD, 0)/(C2.NEXT_SEQ_NUM - -- 6797274 changes
418: C3.NEXT_SEQ_NUM)) * srv_factor, 5)
419: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,
420: BOM_CALENDAR_DATES C3,
421: BOM_PERIOD_START_DATES W1, MRP_FORECAST_DATES F,
422: MRP_FORECAST_DESIGNATORS D1
423: WHERE D1.ORGANIZATION_ID = org_id
424: AND D1.FORECAST_DESIGNATOR = forc_name
425: AND F.ORGANIZATION_ID = org_id

Line 508: BOM_PERIOD_START_DATES W1, MRP_FORECAST_DATES F,

504: ROUND(SUM(ORIGINAL_FORECAST_QUANTITY/
505: (C2.NEXT_SEQ_NUM - C3.NEXT_SEQ_NUM))* ss_percent/100 ,5)
506: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,
507: BOM_CALENDAR_DATES C3,
508: BOM_PERIOD_START_DATES W1, MRP_FORECAST_DATES F,
509: MRP_FORECAST_DESIGNATORS D1
510: WHERE D1.ORGANIZATION_ID = org_id
511: AND D1.FORECAST_DESIGNATOR = forc_name
512: AND F.ORGANIZATION_ID = org_id