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 1416: FROM wip_discrete_jobs wdj

1412: AND wppb.wip_entity_id = we.wip_entity_id
1413: AND (
1414: ( we.entity_type IN (1,3) AND EXISTS (
1415: SELECT 'X'
1416: FROM wip_discrete_jobs wdj
1417: WHERE
1418: wdj.wip_entity_id = wppb.wip_entity_id AND
1419: NVL(wdj.date_closed, l_current_start_date) >= l_current_start_date))
1420: OR (we.entity_type = 4 AND EXISTS (

Line 1494: FROM wip_discrete_jobs wdj

1490: AND wprocd.wip_entity_id = we.wip_entity_id
1491: AND (
1492: ( we.entity_type IN (1,3) AND EXISTS (
1493: SELECT 'X'
1494: FROM wip_discrete_jobs wdj
1495: WHERE
1496: wdj.wip_entity_id = wprocd.wip_entity_id AND
1497: NVL(wdj.date_closed, l_current_start_date) >= l_current_start_date))
1498: OR (we.entity_type = 2 AND EXISTS (