DBA Data[Home] [Help]

APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on EAM_WORK_ORDER_DETAILS

Line 1139: update eam_work_order_details

1135: )
1136: IS
1137:
1138: BEGIN
1139: update eam_work_order_details
1140: SET user_defined_status_id = p_new_status
1141: , program_update_date = SYSDATE
1142: , last_update_date = SYSDATE
1143: , last_updated_by = FND_GLOBAL.user_id

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