APPS.WIP_EAM_WORKREQUEST_PVT dependencies on CSI_ITEM_INSTANCES

Line 147: FROM csi_item_instances

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

Line 924: FROM csi_item_instances

920: BEGIN
921: l_maintenance_object_type := 3; --15898728
922: SELECT instance_id
923: INTO l_new_maintenance_object_id
924: FROM csi_item_instances
925: WHERE
926: inventory_item_id = l_new_asset_group_id AND
927: serial_number = l_new_asset_number;
928: EXCEPTION

Line 2661: FROM csi_item_instances cii, mtl_system_items msi

2657: -- check that the asset is maintainable
2658:
2659: SELECT nvl(cii.maintainable_flag, 'Y'), cii.serial_number, msi.eam_item_type
2660: INTO l_dummy_char, l_asset_number,l_dummy_val
2661: FROM csi_item_instances cii, mtl_system_items msi
2662: WHERE cii.instance_id = p_maintenance_object_id AND
2663: cii.last_vld_organization_id = msi.organization_id AND
2664: cii.inventory_item_id = msi.inventory_item_id ;
2665:

Line 2694: FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MSI

2690: -- check that the asset is maintainable
2691: -- Bug # 3553217.
2692: SELECT nvl(cii.maintainable_flag, 'Y'), eam_item_type
2693: INTO l_dummy_char, l_dummy_val
2694: FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MSI
2695: WHERE cii.serial_number = p_asset_number AND
2696: cii.inventory_item_id = p_asset_group_id AND
2697: cii.last_vld_organization_id = msi.organization_id AND
2698: cii.inventory_item_id = msi.inventory_item_id ;

Line 2987: FROM CSI_ITEM_INSTANCES cii

2983: -- If Capital Asset or Rebuild Inventory
2984: BEGIN
2985: -- check that the asset is maintainable
2986: SELECT nvl(maintainable_flag, 'Y') into l_dummy_char
2987: FROM CSI_ITEM_INSTANCES cii
2988: WHERE cii.serial_number = p_asset_number AND
2989: cii.inventory_item_id = p_asset_group_id;
2990:
2991: EXCEPTION

Line 3437: from csi_item_instances cii

3433: IF (p_asset_group_id <> 0 AND p_asset_group_id IS NOT NULL) THEN
3434: begin
3435:
3436: select instance_id into l_instance_id
3437: from csi_item_instances cii
3438: where cii.inventory_item_id = p_asset_group_id
3439: and cii.serial_number = p_asset_number;
3440: exception
3441: when others then

Line 3470: from csi_item_instances cii

3466: IF (p_asset_group_id <> 0 AND p_asset_group_id IS NOT NULL) THEN
3467: begin
3468:
3469: select instance_id into l_instance_id
3470: from csi_item_instances cii
3471: where cii.inventory_item_id = p_asset_group_id
3472: and cii.serial_number = p_asset_number;
3473:
3474: