ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 1DB56639CF414567E0630100007FE9C8 select xxen_util.meaning(decode(mtst.user_defined_flag,'Y','U','S'),'CUSTOMIZATION_LEVEL',0) source, mtst.transaction_source_type_name source_type, mtst.description, xxen_util.meaning(decode(mtst.user_defined_flag,'Y',mtst.validated_flag),'YES_NO_SYS',700) validation_type, mtst.descriptive_flex_context_code context, mtst.disable_date inactive_on, &dff_columns xxen_util.user_name(mtst.created_by) created_by, xxen_util.client_time(mtst.creation_date) creation_date, xxen_util.user_name(mtst.last_updated_by) last_updated_by, xxen_util.client_time(mtst.last_update_date) last_update_date, mtst.transaction_source_type_id from mtl_txn_source_types mtst where 1=1 order by mtst.user_defined_flag, mtst.transaction_source_type_name Y US INV Transaction Source Types Enginatics &dff_columns 1=1 1 10 1=1 mtst.user_defined_flag=decode(:source,'S','N','Y') LOV custom Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_code in ('U','S') and flvv.lookup_type='CUSTOMIZATION_LEVEL' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.lookup_code US Source 2 20 &dff_columns select xxen_util.dff_columns(p_table_name=>'mtl_txn_source_types') sql_text from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show DFF Attributes