DBA Data[Home] [Help]

APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on WIP_DJ_CLOSE_TEMP

Line 1147: FROM WIP_DJ_CLOSE_TEMP wdct, wip_discrete_jobs wdj

1143: , last_updated_by = FND_GLOBAL.user_id
1144: , last_update_login = FND_GLOBAL.login_id
1145: WHERE organization_id = p_organization_id
1146: AND WIP_ENTITY_ID IN (SELECT wdct.WIP_ENTITY_ID
1147: FROM WIP_DJ_CLOSE_TEMP wdct, wip_discrete_jobs wdj
1148: WHERE wdct.ORGANIZATION_ID = p_organization_id
1149: AND wdct.GROUP_ID = p_group_id
1150: and wdj.wip_entity_id = wdct.WIP_ENTITY_ID
1151: and wdj.status_type = WIP_CONSTANTS.PEND_CLOSE);

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