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.CSTPFCHK dependencies on WIP_DISCRETE_JOBS

Line 1421: FROM wip_discrete_jobs wdj

1417: AND wppb.wip_entity_id = we.wip_entity_id
1418: AND (
1419: ( we.entity_type IN (1,3) AND EXISTS (
1420: SELECT 'X'
1421: FROM wip_discrete_jobs wdj
1422: WHERE
1423: wdj.wip_entity_id = wppb.wip_entity_id AND
1424: NVL(wdj.date_closed, l_current_start_date) >= l_current_start_date))
1425: OR (we.entity_type = 4 AND EXISTS (

Line 1499: FROM wip_discrete_jobs wdj

1495: AND wprocd.wip_entity_id = we.wip_entity_id
1496: AND (
1497: ( we.entity_type IN (1,3) AND EXISTS (
1498: SELECT 'X'
1499: FROM wip_discrete_jobs wdj
1500: WHERE
1501: wdj.wip_entity_id = wprocd.wip_entity_id AND
1502: NVL(wdj.date_closed, l_current_start_date) >= l_current_start_date))
1503: OR (we.entity_type = 2 AND EXISTS (