APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on WIP_DISCRETE_JOBS

Line 116: -- set out params by query wip_discrete_jobs table

112: p_x_return_status := FND_API.G_RET_STS_ERROR;
113: return;
114: END IF;
115:
116: -- set out params by query wip_discrete_jobs table
117: select parent_wip_entity_id,
118: asset_group_id,
119: asset_number,
120: organization_id,

Line 133: from wip_discrete_jobs

129: l_rebuild_item_id,
130: x_manual_rebuild_flag,
131: l_status_type,
132: x_shutdown_type
133: from wip_discrete_jobs
134: where wip_entity_id = p_wip_entity_id;
135: if l_rebuild_item_id is null then
136: x_rebuild_jobs := 'N';
137: else

Line 530: from wip_discrete_jobs

526:
527: -- Bug 3676937 . For CMRO work orders need not check completion subinventory
528: select maintenance_object_source, rebuild_item_id
529: into l_maintenance_source_id, l_rebuild_item_id
530: from wip_discrete_jobs
531: where wip_entity_id = p_wip_entity_id;
532:
533:
534: if l_maintenance_source_id = 2 then -- for CMRO no inventory item info is required.

Line 1044: select count(*) into l_count from wip_discrete_jobs where

1040:
1041: BEGIN
1042:
1043: -- Validate WIP Entity Id
1044: select count(*) into l_count from wip_discrete_jobs where
1045: wip_entity_id = p_wip_entity_id and
1046: organization_id = p_organization_id;
1047: if l_count <> 1 then
1048: x_return_status := 'E';

Line 1054: update wip_discrete_jobs set manual_rebuild_flag = p_manual_rebuild_flag

1050: end if;
1051:
1052: -- Set Manual Rebuild Flag
1053: IF p_manual_rebuild_flag is not null then
1054: update wip_discrete_jobs set manual_rebuild_flag = p_manual_rebuild_flag
1055: where wip_entity_id = p_wip_entity_id and
1056: organization_id = p_organization_id;
1057: END IF;
1058:

Line 1082: select count(*) into l_count from wip_discrete_jobs where

1078:
1079: BEGIN
1080:
1081: -- Validate WIP Entity Id
1082: select count(*) into l_count from wip_discrete_jobs where
1083: wip_entity_id = p_wip_entity_id and
1084: organization_id = p_organization_id;
1085: if l_count <> 1 then
1086: x_return_status := 'E';

Line 1101: update wip_discrete_jobs set owning_department = p_owning_department

1097: end if;
1098:
1099: -- Set Owning Department
1100: IF p_owning_department is not null then
1101: update wip_discrete_jobs set owning_department = p_owning_department
1102: where wip_entity_id = p_wip_entity_id and
1103: organization_id = p_organization_id;
1104: END IF;
1105:

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