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.EAM_WORKORDERTRANSACTIONS_PUB dependencies on WIP_ENTITIES

Line 107: from wip_entities

103: END IF;
104:
105: -- check wip_entity_id points to a valid eam workorder
106: select entity_type into l_entity_type
107: from wip_entities
108: where wip_entity_id = p_wip_entity_id;
109: if (NOT l_entity_type = 6) then
110: -- not an open eam job
111: FND_MESSAGE.set_name('EAM', 'EAM_NOT_OPEN_EAM_JOB');

Line 847: where organization_id = (select organization_id from wip_entities where wip_entity_id=p_wip_entity_id)

843:
844: select nvl(min(period_start_date),sysdate+1)
845: into l_open_acct_per_date
846: from org_acct_periods
847: where organization_id = (select organization_id from wip_entities where wip_entity_id=p_wip_entity_id)
848: and open_flag = 'Y';
849:
850: if (l_actual_start_date is not null) then
851:

Line 1194: FROM wip_discrete_jobs wdj, wip_dj_close_temp wdct, eam_work_order_details ewod, wip_entities we

1190: CURSOR workorders
1191: IS
1192: SELECT wdj.wip_entity_id, we.wip_entity_name,
1193: wdj.status_type, wdj.organization_id, ewod.user_defined_status_id, ewod.workflow_type
1194: FROM wip_discrete_jobs wdj, wip_dj_close_temp wdct, eam_work_order_details ewod, wip_entities we
1195: WHERE wdct.group_id = p_group_id
1196: and wdct.wip_entity_id = wdj.wip_entity_id
1197: and wdct.organization_id = wdj.organization_id
1198: and wdj.wip_entity_id = ewod.wip_entity_id