DBA Data[Home] [Help]

APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on EAM_WORK_ORDER_DETAILS

Line 1141: update eam_work_order_details

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

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

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