APPS.WIP_EAM_UTILS dependencies on CSI_ITEM_INSTANCES

Line 74: from csi_item_instances cii

70: --1.1 Derive Instance_id
71: if p_serial_number is not null then
72: select cii.instance_id
73: into l_instance_id
74: from csi_item_instances cii
75: where cii.inventory_item_id = l_inv_item_id
76: and cii.serial_number = p_serial_number;
77:
78: l_maintenance_object_type := 3;

Line 371: from csi_item_instances cii

367: --1 Derive Instance_id
368: if p_serial_number is not null then
369: select cii.instance_id
370: into l_instance_id
371: from csi_item_instances cii
372: where cii.inventory_item_id = p_asset_group_id
373: and cii.serial_number = p_serial_number;
374:
375: l_maintenance_object_type := 3;