APPS.EAM_WO_VALIDATE_PVT dependencies on WIP_DISCRETE_JOBS

Line 389: from wip_discrete_jobs

385: IF p_eam_wo_rec.maintenance_object_source = 1 THEN
386:
387: IF p_eam_wo_rec.transaction_type <> EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
388: select maintenance_object_id into l_old_eam_wo_moid
389: from wip_discrete_jobs
390: where wip_entity_id = p_eam_wo_rec.wip_entity_id
391: and organization_id = p_eam_wo_rec.organization_id
392: and rownum = 1;
393: END IF;

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

1203: 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;
1204:
1205: SELECT 1
1206: INTO g_dummy
1207: FROM mtl_object_genealogy mog, mtl_serial_numbers msn, wip_discrete_jobs wdj,
1208: mtl_serial_numbers msn1, csi_item_instances cii, mtl_parameters mp, csi_item_instances cii1
1209: WHERE p_eam_wo_rec.rebuild_item_id is not null
1210: and cii.instance_id = p_eam_wo_rec.maintenance_object_id
1211: and cii.last_vld_organization_id = mp.organization_id

Line 1235: FROM wip_discrete_jobs

1231:
1232: ELSE
1233: SELECT 1 INTO
1234: g_dummy
1235: FROM wip_discrete_jobs
1236: WHERE
1237: p_eam_wo_rec.rebuild_item_id is not null
1238: and organization_id = p_eam_wo_rec.organization_id
1239: and wip_entity_id = p_eam_wo_rec.parent_wip_entity_id