DBA Data[Home] [Help]

APPS.MRP_FORECAST dependencies on MTL_PARAMETERS

Line 368: MTL_PARAMETERS PARAM,

364: MRP_FQ.NUMBER2, /* (added for web inquiries) */
365: MRP_FQ.NUMBER1, /* (added for web inquiries) */
366: MRP_FQ.CHAR1 /* (added for web inquiries) */
367: FROM BOM_CALENDAR_DATES DATES,
368: MTL_PARAMETERS PARAM,
369: MRP_FORM_QUERY MRP_FQ
370: WHERE DATES.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
371: AND DATES.CALENDAR_CODE = PARAM.CALENDAR_CODE
372: AND DATES.SEQ_NUM is not NULL

Line 508: MTL_PARAMETERS PARAM,

504: MRP_FQ.NUMBER2, /* (added for web inquiries) */
505: MRP_FQ.NUMBER1, /* (added for web inquiries) */
506: MRP_FQ.CHAR1 /* (added for web inquiries) */
507: FROM BOM_CAL_WEEK_START_DATES DATES,
508: MTL_PARAMETERS PARAM,
509: MRP_FORM_QUERY MRP_FQ
510: WHERE DATES.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
511: AND DATES.CALENDAR_CODE = PARAM.CALENDAR_CODE
512: AND DATES.WEEK_START_DATE BETWEEN arg_bucket_start_date

Line 645: FROM MTL_PARAMETERS PARAM,

641: MRP_FQ.NUMBER7),0)))),0), 6),
642: MRP_FQ.NUMBER2, /* (added for web inquiries) */
643: MRP_FQ.NUMBER1, /* (added for web inquiries) */
644: MRP_FQ.CHAR1 /* (added for web inquiries) */
645: FROM MTL_PARAMETERS PARAM,
646: BOM_PERIOD_START_DATES DATES,
647: MRP_FORM_QUERY MRP_FQ
648: WHERE DATES.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
649: AND DATES.CALENDAR_CODE = PARAM.CALENDAR_CODE