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.CAC_AVLBLTY_PVT dependencies on CAC_SR_TEMPLATES_B

Line 1397: FROM CAC_SR_TEMPLATES_B CSTB,

1393: CSPB.START_TIME_MS,
1394: CSPB.DURATION,
1395: CSPB.DURATION_UOM,
1396: CSTB.TEMPLATE_LENGTH_DAYS
1397: FROM CAC_SR_TEMPLATES_B CSTB,
1398: CAC_SR_PERIODS_B CSPB,
1399: (SELECT CSTD.TEMPLATE_DETAIL_ID,
1400: CSTD.TEMPLATE_DETAIL_SEQ,
1401: CSTD.TEMPLATE_ID,

Line 2138: , CAC_SR_TEMPLATES_B CSTB

2134: , CSTB.TEMPLATE_LENGTH_DAYS
2135: , CSSB.START_DATE_ACTIVE
2136: , CSSB.END_DATE_ACTIVE
2137: FROM CAC_SR_SCHEDULES_B CSSB
2138: , CAC_SR_TEMPLATES_B CSTB
2139: WHERE CSSB.SCHEDULE_ID = b_schedule_id
2140: AND CSTB.TEMPLATE_ID = CSSB.TEMPLATE_ID;
2141:
2142: l_period_data PERIOD_TBL_TYPE;