DBA Data[Home] [Help]

APPS.EAM_WL_UTIL_PKG dependencies on CSI_ITEM_INSTANCES

Line 131: FROM csi_item_instances cii, mtl_parameters mp

127: FUNCTION get_serial_description( p_serial_number VARCHAR2, p_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2
128: IS
129: CURSOR get_value IS
130: SELECT cii.instance_description
131: FROM csi_item_instances cii, mtl_parameters mp
132: WHERE cii.serial_number = p_serial_number
133: AND cii.inventory_item_id = p_item_id
134: AND cii.last_vld_organization_id = mp.organization_id
135: AND mp.maint_organization_id = p_organization_id;