APPS.WIP_EAM_WORKREQUEST_PVT dependencies on CSI_ITEM_INSTANCES

Line 146: FROM csi_item_instances

142: BEGIN
143: l_maintenance_object_type := 3;
144: SELECT instance_id
145: INTO l_maintenance_object_id
146: FROM csi_item_instances
147: WHERE
148: inventory_item_id = p_asset_group_id AND
149: serial_number = p_asset_number;
150: EXCEPTION

Line 895: FROM csi_item_instances

891: IF (l_new_asset_group_id <> 0 AND l_new_asset_group_id IS NOT NULL) THEN
892: BEGIN
893: SELECT instance_id
894: INTO l_new_maintenance_object_id
895: FROM csi_item_instances
896: WHERE
897: inventory_item_id = l_new_asset_group_id AND
898: serial_number = l_new_asset_number;
899: EXCEPTION

Line 2614: FROM csi_item_instances cii, mtl_system_items msi

2610: -- check that the asset is maintainable
2611:
2612: SELECT nvl(cii.maintainable_flag, 'Y'), cii.serial_number, msi.eam_item_type
2613: INTO l_dummy_char, l_asset_number,l_dummy_val
2614: FROM csi_item_instances cii, mtl_system_items msi
2615: WHERE cii.instance_id = p_maintenance_object_id AND
2616: cii.last_vld_organization_id = msi.organization_id AND
2617: cii.inventory_item_id = msi.inventory_item_id ;
2618:

Line 2647: FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MSI

2643: -- check that the asset is maintainable
2644: -- Bug # 3553217.
2645: SELECT nvl(cii.maintainable_flag, 'Y'), eam_item_type
2646: INTO l_dummy_char, l_dummy_val
2647: FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MSI
2648: WHERE cii.serial_number = p_asset_number AND
2649: cii.inventory_item_id = p_asset_group_id AND
2650: cii.last_vld_organization_id = msi.organization_id AND
2651: cii.inventory_item_id = msi.inventory_item_id ;

Line 2931: FROM CSI_ITEM_INSTANCES cii

2927: -- If Capital Asset or Rebuild Inventory
2928: BEGIN
2929: -- check that the asset is maintainable
2930: SELECT nvl(maintainable_flag, 'Y') into l_dummy_char
2931: FROM CSI_ITEM_INSTANCES cii
2932: WHERE cii.serial_number = p_asset_number AND
2933: cii.inventory_item_id = p_asset_group_id;
2934:
2935: EXCEPTION

Line 3375: from csi_item_instances cii

3371: IF (p_asset_group_id <> 0 AND p_asset_group_id IS NOT NULL) THEN
3372: begin
3373:
3374: select instance_id into l_instance_id
3375: from csi_item_instances cii
3376: where cii.inventory_item_id = p_asset_group_id
3377: and cii.serial_number = p_asset_number;
3378: exception
3379: when others then

Line 3408: from csi_item_instances cii

3404: IF (p_asset_group_id <> 0 AND p_asset_group_id IS NOT NULL) THEN
3405: begin
3406:
3407: select instance_id into l_instance_id
3408: from csi_item_instances cii
3409: where cii.inventory_item_id = p_asset_group_id
3410: and cii.serial_number = p_asset_number;
3411:
3412: