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.WSMPLOAD dependencies on WSM_SM_RESULTING_JOBS

Line 124: wsm_sm_resulting_jobs wsrj

120: wdj.bom_revision_date,
121: wdj.wip_supply_type
122: FROM wsm_lot_based_jobs wlbj,
123: wip_discrete_jobs wdj,
124: wsm_sm_resulting_jobs wsrj
125: WHERE wsrj.internal_group_id = WSMPLOAD.G_GROUP_ID
126: AND wsrj.wip_entity_id = wlbj.wip_entity_id
127: AND wlbj.wip_entity_id = wdj.wip_entity_id
128: AND wdj.status_type = 3 -- Released jobs

Line 140: wsm_sm_resulting_jobs wsrj

136: wdj.organization_id,
137: decode(wlbj.on_rec_path, 'Y', WIP_CONSTANTS.MIDPOINT_FORWARDS, WIP_CONSTANTS.CURRENT_OP) inf_sch_mode
138: FROM wsm_lot_based_jobs wlbj,
139: wip_discrete_jobs wdj,
140: wsm_sm_resulting_jobs wsrj
141: WHERE wsrj.internal_group_id = WSMPLOAD.G_GROUP_ID
142: AND wsrj.wip_entity_id = wlbj.wip_entity_id
143: AND wlbj.wip_entity_id = wdj.wip_entity_id
144: AND wdj.status_type = 3 -- Released jobs

Line 189: -- wsm_sm_resulting_jobs wsrj

185: -- SELECT count(distinct(wdj.wip_entity_id))
186: -- INTO l_temp
187: -- FROM wsm_lot_based_jobs wlbj,
188: -- wip_discrete_jobs wdj,
189: -- wsm_sm_resulting_jobs wsrj
190: -- WHERE wsrj.internal_group_id = WSMPLOAD.G_GROUP_ID
191: -- AND wsrj.wip_entity_id = wlbj.wip_entity_id
192: -- AND wlbj.wip_entity_id = wdj.wip_entity_id
193: -- AND wdj.status_type = 3 -- Released jobs