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.MRP_MRPRPROP_XMLP_PKG dependencies on BOM_CALENDAR_DATES

Line 1097: BOM_CALENDAR_DATES CAL1,

1093: CAL1.NEXT_SEQ_NUM,
1094: CAL2.NEXT_SEQ_NUM
1095: INTO START_SEQ_NUM,END_SEQ_NUM
1096: FROM
1097: BOM_CALENDAR_DATES CAL1,
1098: BOM_CALENDAR_DATES CAL2
1099: WHERE CAL1.CALENDAR_CODE = CAL2.CALENDAR_CODE
1100: AND CAL1.CALENDAR_CODE = CAL_CODE
1101: AND CAL1.EXCEPTION_SET_ID = CAL2.EXCEPTION_SET_ID

Line 1098: BOM_CALENDAR_DATES CAL2

1094: CAL2.NEXT_SEQ_NUM
1095: INTO START_SEQ_NUM,END_SEQ_NUM
1096: FROM
1097: BOM_CALENDAR_DATES CAL1,
1098: BOM_CALENDAR_DATES CAL2
1099: WHERE CAL1.CALENDAR_CODE = CAL2.CALENDAR_CODE
1100: AND CAL1.CALENDAR_CODE = CAL_CODE
1101: AND CAL1.EXCEPTION_SET_ID = CAL2.EXCEPTION_SET_ID
1102: AND CAL1.EXCEPTION_SET_ID = EXC_SET_ID

Line 1116: BOM_CALENDAR_DATES CAL1,

1112: ,START_SEQ_NUM)))
1113: ,0)
1114: INTO DAY_FC_QTY
1115: FROM
1116: BOM_CALENDAR_DATES CAL1,
1117: BOM_CALENDAR_DATES CAL2,
1118: MRP_FORECAST_DATES FC,
1119: MRP_FORECAST_DESIGNATORS DESIG1,
1120: MRP_FORECAST_DESIGNATORS DESIG2

Line 1117: BOM_CALENDAR_DATES CAL2,

1113: ,0)
1114: INTO DAY_FC_QTY
1115: FROM
1116: BOM_CALENDAR_DATES CAL1,
1117: BOM_CALENDAR_DATES CAL2,
1118: MRP_FORECAST_DATES FC,
1119: MRP_FORECAST_DESIGNATORS DESIG1,
1120: MRP_FORECAST_DESIGNATORS DESIG2
1121: WHERE DESIG2.FORECAST_DESIGNATOR = FORECAST_DESIG

Line 1156: BOM_CALENDAR_DATES CAL1,

1152: ,START_SEQ_NUM)))
1153: ,0)
1154: INTO WEEK_FC_QTY
1155: FROM
1156: BOM_CALENDAR_DATES CAL1,
1157: BOM_CALENDAR_DATES CAL2,
1158: BOM_CAL_WEEK_START_DATES WEEK,
1159: MRP_FORECAST_DATES FC,
1160: MRP_FORECAST_DESIGNATORS DESIG1,

Line 1157: BOM_CALENDAR_DATES CAL2,

1153: ,0)
1154: INTO WEEK_FC_QTY
1155: FROM
1156: BOM_CALENDAR_DATES CAL1,
1157: BOM_CALENDAR_DATES CAL2,
1158: BOM_CAL_WEEK_START_DATES WEEK,
1159: MRP_FORECAST_DATES FC,
1160: MRP_FORECAST_DESIGNATORS DESIG1,
1161: MRP_FORECAST_DESIGNATORS DESIG2

Line 1202: BOM_CALENDAR_DATES CAL1,

1198: ,START_SEQ_NUM)))
1199: ,0)
1200: INTO PERIOD_FC_QTY
1201: FROM
1202: BOM_CALENDAR_DATES CAL1,
1203: BOM_CALENDAR_DATES CAL2,
1204: BOM_PERIOD_START_DATES PER,
1205: MRP_FORECAST_DATES FC,
1206: MRP_FORECAST_DESIGNATORS DESIG1,

Line 1203: BOM_CALENDAR_DATES CAL2,

1199: ,0)
1200: INTO PERIOD_FC_QTY
1201: FROM
1202: BOM_CALENDAR_DATES CAL1,
1203: BOM_CALENDAR_DATES CAL2,
1204: BOM_PERIOD_START_DATES PER,
1205: MRP_FORECAST_DATES FC,
1206: MRP_FORECAST_DESIGNATORS DESIG1,
1207: MRP_FORECAST_DESIGNATORS DESIG2

Line 1397: BOM_CALENDAR_DATES CAL1,

1393: TRUNC(SYSDATE),
1394: CAL2.CALENDAR_DATE
1395: INTO START_DATE,END_DATE
1396: FROM
1397: BOM_CALENDAR_DATES CAL1,
1398: BOM_CALENDAR_DATES CAL2
1399: WHERE CAL1.CALENDAR_CODE = CAL_CODE
1400: AND CAL1.EXCEPTION_SET_ID = EXC_SET_ID
1401: AND CAL1.CALENDAR_CODE = CAL2.CALENDAR_CODE

Line 1398: BOM_CALENDAR_DATES CAL2

1394: CAL2.CALENDAR_DATE
1395: INTO START_DATE,END_DATE
1396: FROM
1397: BOM_CALENDAR_DATES CAL1,
1398: BOM_CALENDAR_DATES CAL2
1399: WHERE CAL1.CALENDAR_CODE = CAL_CODE
1400: AND CAL1.EXCEPTION_SET_ID = EXC_SET_ID
1401: AND CAL1.CALENDAR_CODE = CAL2.CALENDAR_CODE
1402: AND CAL1.EXCEPTION_SET_ID = CAL2.EXCEPTION_SET_ID

Line 1408: ,'Error getting data from bom_calendar_dates, make sure calendar is extended ')*/NULL;

1404: AND CAL2.SEQ_NUM = ROUND(CAL1.NEXT_SEQ_NUM + ORD_LEAD_TIME);
1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: /*SRW.MESSAGE(100
1408: ,'Error getting data from bom_calendar_dates, make sure calendar is extended ')*/NULL;
1409: /*SRW.MESSAGE(100
1410: ,'Calendar_code = ' || CAL_CODE)*/NULL;
1411: /*SRW.MESSAGE(100
1412: ,'Organization Id = ' || ORG_ID)*/NULL;