APPS.EAM_WO_VALIDATE_PVT dependencies on WIP_DISCRETE_JOBS

Line 423: from wip_discrete_jobs

419: IF p_eam_wo_rec.maintenance_object_source = 1 THEN
420:
421: IF p_eam_wo_rec.transaction_type <> EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
422: select maintenance_object_id into l_old_eam_wo_moid
423: from wip_discrete_jobs
424: where wip_entity_id = p_eam_wo_rec.wip_entity_id
425: and organization_id = p_eam_wo_rec.organization_id
426: and rownum = 1;
427: END IF;

Line 1287: FROM mtl_object_genealogy mog, mtl_serial_numbers msn, wip_discrete_jobs wdj,

1283: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating parent_wip_entity_id . rebuild status=' || l_rebuild_status); END IF;
1284:
1285: SELECT 1
1286: INTO g_dummy
1287: FROM mtl_object_genealogy mog, mtl_serial_numbers msn, wip_discrete_jobs wdj,
1288: mtl_serial_numbers msn1, csi_item_instances cii, mtl_parameters mp, csi_item_instances cii1
1289: WHERE p_eam_wo_rec.rebuild_item_id is not null
1290: and cii.instance_id = p_eam_wo_rec.maintenance_object_id
1291: and cii.last_vld_organization_id = mp.organization_id

Line 1315: FROM wip_discrete_jobs

1311:
1312: ELSE
1313: SELECT 1 INTO
1314: g_dummy
1315: FROM wip_discrete_jobs
1316: WHERE
1317: p_eam_wo_rec.rebuild_item_id is not null
1318: and organization_id = p_eam_wo_rec.organization_id
1319: and wip_entity_id = p_eam_wo_rec.parent_wip_entity_id