eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_SAFETY_STOCKS_PKG dependencies on BOM_CALENDAR_DATES

Line 365: BOM_CALENDAR_DATES C1,

361: SELECT 1,
362: TO_NUMBER(TO_CHAR(C1.CALENDAR_DATE,'J')),
363: ROUND(SUM(NVL(F.FORECAST_MAD, 0)) * srv_factor, 5) -- 6797274 changes
364: FROM
365: BOM_CALENDAR_DATES C1,
366: MRP_FORECAST_DESIGNATORS D1,
367: MRP_FORECAST_DATES F
368: WHERE D1.ORGANIZATION_ID = org_id
369: AND D1.FORECAST_DESIGNATOR = forc_name

Line 386: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,

382: SELECT 2,
383: TO_NUMBER(TO_CHAR(C3.CALENDAR_DATE,'J')),
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

Line 387: BOM_CALENDAR_DATES C3,

383: TO_NUMBER(TO_CHAR(C3.CALENDAR_DATE,'J')),
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

Line 419: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,

415: SELECT 3,
416: TO_NUMBER(TO_CHAR(C3.CALENDAR_DATE,'J')),
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

Line 420: BOM_CALENDAR_DATES C3,

416: TO_NUMBER(TO_CHAR(C3.CALENDAR_DATE,'J')),
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

Line 454: BOM_CALENDAR_DATES C1,

450: SELECT 1,
451: TO_NUMBER(TO_CHAR(C1.CALENDAR_DATE,'J')),
452: ROUND(SUM(F.ORIGINAL_FORECAST_QUANTITY)* ss_percent/100 , 5)
453: FROM
454: BOM_CALENDAR_DATES C1,
455: MRP_FORECAST_DESIGNATORS D1,
456: MRP_FORECAST_DATES F
457: WHERE D1.ORGANIZATION_ID = org_id
458: AND D1.FORECAST_DESIGNATOR = forc_name

Line 474: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,

470: SELECT 2,
471: TO_NUMBER(TO_CHAR(C1.CALENDAR_DATE,'J')),
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

Line 475: BOM_CALENDAR_DATES C3,

471: TO_NUMBER(TO_CHAR(C1.CALENDAR_DATE,'J')),
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

Line 506: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,

502: SELECT 3,
503: TO_NUMBER(TO_CHAR(C1.CALENDAR_DATE,'J')),
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

Line 507: BOM_CALENDAR_DATES C3,

503: TO_NUMBER(TO_CHAR(C1.CALENDAR_DATE,'J')),
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