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_DEFAULT_SHOPFLOORMOVE dependencies on WIP_DISCRETE_JOBS

Line 59: from WIP_DISCRETE_JOBS DJ

55: where we.wip_entity_id = p_wip_entity_id
56: and we.organization_id = p_org_id
57: and (((we.entity_type = WIP_CONSTANTS.DISCRETE)
58: and not exists (select 'X'
59: from WIP_DISCRETE_JOBS DJ
60: where DJ.WIP_ENTITY_ID = p_wip_entity_id
61: and DJ.ORGANIZATION_ID = p_org_id
62: and DJ.COMPLETION_SUBINVENTORY IS NOT NULL))
63: or (we.entity_type = WIP_CONSTANTS.REPETITIVE)

Line 95: from wip_discrete_jobs wdj

91: and msi.organization_id = we.organization_id
92: and msi.lot_control_code = WIP_CONSTANTS.LOT
93: and ( ( we.entity_type = WIP_CONSTANTS.DISCRETE
94: and exists (select 'X'
95: from wip_discrete_jobs wdj
96: where wdj.wip_entity_id = we.wip_entity_id
97: and wdj.organization_id = we.organization_id
98: and wdj.lot_number is null))
99: or (we.entity_type = WIP_CONSTANTS.REPETITIVE) );

Line 177: from WIP_DISCRETE_JOBS wdj, MTL_ITEM_REVISIONS MIR

173: and msi.revision_qty_control_code=2)
174: and ( ( we.entity_type = WIP_CONSTANTS.DISCRETE
175: and not exists (
176: select 'X'
177: from WIP_DISCRETE_JOBS wdj, MTL_ITEM_REVISIONS MIR
178: where wdj.organization_id = we.organization_id
179: and wdj.wip_entity_id = we.wip_entity_id
180: and mir.organization_id = wdj.organization_id
181: and mir.inventory_item_id = we.primary_item_id