APPS.EAM_WO_VALIDATE_PVT dependencies on CSI_ITEM_INSTANCES

Line 433: from csi_item_instances cii, mtl_parameters mp

429: OR (p_eam_wo_rec.transaction_type <> EAM_PROCESS_WO_PVT.G_OPR_CREATE
430: AND l_old_eam_wo_moid <> p_eam_wo_rec.maintenance_object_id) THEN
431: -- Code for create validation
432: select 1 into g_dummy
433: from csi_item_instances cii, mtl_parameters mp
434: where cii.last_vld_organization_id = mp.organization_id
435: and mp.maint_organization_id = p_eam_wo_rec.organization_id
436: and cii.instance_id = p_eam_wo_rec.maintenance_object_id
437: and cii.inventory_item_id = nvl(p_eam_wo_rec.asset_group_id, p_eam_wo_rec.rebuild_item_id)

Line 859: from csi_item_instances cii, mtl_parameters mp

855: OR (p_eam_wo_rec.transaction_type <> EAM_PROCESS_WO_PVT.G_OPR_CREATE
856: AND p_eam_wo_rec.maintenance_object_id <> p_old_eam_wo_rec.maintenance_object_id) THEN
857: -- Code for creation
858: select 1 into g_dummy
859: from csi_item_instances cii, mtl_parameters mp
860: where cii.last_vld_organization_id = mp.organization_id
861: and mp.maint_organization_id = p_eam_wo_rec.organization_id
862: and cii.instance_id = p_eam_wo_rec.maintenance_object_id;
863: END IF;

Line 960: from mtl_system_items msi, csi_item_instances cii, mtl_parameters mp

956: end if;
957:
958: select 1
959: into g_dummy
960: from mtl_system_items msi, csi_item_instances cii, mtl_parameters mp
961: where cii.inventory_item_id = p_eam_wo_rec.asset_group_id
962: and cii.inventory_item_id = msi.inventory_item_id
963: and cii.last_vld_organization_id = mp.organization_id
964: and msi.organization_id = mp.organization_id

Line 1004: from csi_item_instances cii

1000:
1001: /* In update mode do not check the current maintenance organization*/
1002: select 1
1003: into g_dummy
1004: from csi_item_instances cii
1005: where cii.inventory_item_id = p_eam_wo_rec.asset_group_id
1006: and cii.serial_number = p_eam_wo_rec.asset_number
1007: and nvl(cii.maintainable_flag, 'Y') = 'Y'
1008: and nvl(cii.active_start_date, sysdate-1) <= sysdate

Line 1147: from csi_item_instances cii, mtl_parameters mp

1143: p_eam_wo_rec.rebuild_serial_number is not null) then
1144:
1145: select 1
1146: into g_dummy
1147: from csi_item_instances cii, mtl_parameters mp
1148: where cii.inventory_item_id = p_eam_wo_rec.rebuild_item_id
1149: and cii.last_vld_organization_id = mp.organization_id
1150: and mp.maint_organization_id = p_eam_wo_rec.organization_id
1151: and cii.serial_number = p_eam_wo_rec.rebuild_serial_number

Line 1288: mtl_serial_numbers msn1, csi_item_instances cii, mtl_parameters mp, csi_item_instances cii1

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
1292: and mp.maint_organization_id = p_eam_wo_rec.organization_id