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_TMPL_DETAILS

Line 1334: FROM CAC_SR_TMPL_DETAILS CSTD

1330: CSTD.TEMPLATE_DETAIL_SEQ,
1331: CSTD.TEMPLATE_ID,
1332: CSTD.CHILD_PERIOD_ID,
1333: CSTD.CHILD_TEMPLATE_ID
1334: FROM CAC_SR_TMPL_DETAILS CSTD
1335: START WITH CSTD.TEMPLATE_ID = b_tmpl_id
1336: CONNECT BY PRIOR CSTD.CHILD_TEMPLATE_ID = CSTD.TEMPLATE_ID
1337: ORDER SIBLINGS BY TEMPLATE_DETAIL_SEQ) DTLS
1338: WHERE CSPB.PERIOD_ID(+) = DTLS.CHILD_PERIOD_ID

Line 1404: FROM CAC_SR_TMPL_DETAILS CSTD

1400: CSTD.TEMPLATE_DETAIL_SEQ,
1401: CSTD.TEMPLATE_ID,
1402: CSTD.CHILD_PERIOD_ID,
1403: CSTD.CHILD_TEMPLATE_ID
1404: FROM CAC_SR_TMPL_DETAILS CSTD
1405: START WITH CSTD.TEMPLATE_ID = b_tmpl_id
1406: CONNECT BY PRIOR CSTD.CHILD_TEMPLATE_ID = CSTD.TEMPLATE_ID
1407: ORDER SIBLINGS BY TEMPLATE_DETAIL_SEQ) DTLS
1408: WHERE CSTB.TEMPLATE_ID(+) = DTLS.CHILD_TEMPLATE_ID

Line 1577: FROM CAC_SR_TMPL_DETAILS CSTD

1573: CSTD.CHILD_PERIOD_ID,
1574: CSTD.CHILD_TEMPLATE_ID,
1575: CSTD.DAY_START,
1576: CSTD.DAY_STOP
1577: FROM CAC_SR_TMPL_DETAILS CSTD
1578: START WITH CSTD.TEMPLATE_ID = b_tmpl_id
1579: CONNECT BY PRIOR CSTD.CHILD_TEMPLATE_ID = CSTD.TEMPLATE_ID
1580: ORDER SIBLINGS BY TEMPLATE_DETAIL_SEQ) DTLS
1581: WHERE CSPB.PERIOD_ID(+) = DTLS.CHILD_PERIOD_ID