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

Line 2113: FROM wip_discrete_jobs wdj

2109: l_wip_entity_id NUMBER;
2110:
2111: cursor l_always_cursor IS
2112: SELECT wip_entity_id
2113: FROM wip_discrete_jobs wdj
2114: WHERE wdj.organization_id = p_org_id
2115: AND wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
2116: WIP_CONSTANTS.COMP_CHRG)
2117: AND wdj.wip_entity_id IN (SELECT wip_entity_id

Line 2130: FROM wip_discrete_jobs wdj

2126: --
2127: /*
2128: cursor l_1to1_cursor IS
2129: SELECT wip_entity_id
2130: FROM wip_discrete_jobs wdj
2131: WHERE wdj.organization_id = p_org_id
2132: AND wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
2133: WIP_CONSTANTS.COMP_CHRG)
2134: AND wdj.wip_entity_id IN (SELECT wip_entity_id

Line 2155: FROM wip_discrete_jobs wdj, wip_reservations_v wrv

2151: */
2152:
2153: Cursor l_1to1_cursor IS
2154: SELECT wdj.wip_entity_id
2155: FROM wip_discrete_jobs wdj, wip_reservations_v wrv
2156: WHERE wdj.organization_id = p_org_id
2157: AND wdj.organization_id = wrv.organization_id
2158: AND wdj.status_type IN (WIP_CONSTANTS.UNRELEASED,
2159: WIP_CONSTANTS.RELEASED,

Line 2341: from wip_move_txn_interface wmti, wip_discrete_jobs wdj

2337: wdj.primary_item_id,
2338: wdj.start_quantity,
2339: wdj.quantity_completed,
2340: wdj.quantity_scrapped
2341: from wip_move_txn_interface wmti, wip_discrete_jobs wdj
2342: where wmti.group_id = p_group_id
2343: and wmti.wip_entity_id = wdj.wip_entity_id
2344: and wmti.organization_id = wdj.organization_id
2345: and wmti.process_phase = 2