APPS.EAM_WO_VALIDATE_PVT dependencies on CSI_ITEM_INSTANCES

Line 399: from csi_item_instances cii, mtl_parameters mp

395: OR (p_eam_wo_rec.transaction_type <> EAM_PROCESS_WO_PVT.G_OPR_CREATE
396: AND l_old_eam_wo_moid <> p_eam_wo_rec.maintenance_object_id) THEN
397: -- Code for create validation
398: select 1 into g_dummy
399: from csi_item_instances cii, mtl_parameters mp
400: where cii.last_vld_organization_id = mp.organization_id
401: and mp.maint_organization_id = p_eam_wo_rec.organization_id
402: and cii.instance_id = p_eam_wo_rec.maintenance_object_id
403: and cii.inventory_item_id = nvl(p_eam_wo_rec.asset_group_id, p_eam_wo_rec.rebuild_item_id)

Line 793: from csi_item_instances cii, mtl_parameters mp

789: OR (p_eam_wo_rec.transaction_type <> EAM_PROCESS_WO_PVT.G_OPR_CREATE
790: AND p_eam_wo_rec.maintenance_object_id <> p_old_eam_wo_rec.maintenance_object_id) THEN
791: -- Code for creation
792: select 1 into g_dummy
793: from csi_item_instances cii, mtl_parameters mp
794: where cii.last_vld_organization_id = mp.organization_id
795: and mp.maint_organization_id = p_eam_wo_rec.organization_id
796: and cii.instance_id = p_eam_wo_rec.maintenance_object_id;
797: END IF;

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

890: end if;
891:
892: select 1
893: into g_dummy
894: from mtl_system_items msi, csi_item_instances cii, mtl_parameters mp
895: where cii.inventory_item_id = p_eam_wo_rec.asset_group_id
896: and cii.inventory_item_id = msi.inventory_item_id
897: and cii.last_vld_organization_id = mp.organization_id
898: and msi.organization_id = mp.organization_id

Line 938: from csi_item_instances cii

934:
935: /* In update mode do not check the current maintenance organization*/
936: select 1
937: into g_dummy
938: from csi_item_instances cii
939: where cii.inventory_item_id = p_eam_wo_rec.asset_group_id
940: and cii.serial_number = p_eam_wo_rec.asset_number
941: and nvl(cii.maintainable_flag, 'Y') = 'Y'
942: and nvl(cii.active_start_date, sysdate-1) <= sysdate

Line 1067: from csi_item_instances cii, mtl_parameters mp

1063: p_eam_wo_rec.rebuild_serial_number is not null) then
1064:
1065: select 1
1066: into g_dummy
1067: from csi_item_instances cii, mtl_parameters mp
1068: where cii.inventory_item_id = p_eam_wo_rec.rebuild_item_id
1069: and cii.last_vld_organization_id = mp.organization_id
1070: and mp.maint_organization_id = p_eam_wo_rec.organization_id
1071: and cii.serial_number = p_eam_wo_rec.rebuild_serial_number

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

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