INV Transaction Source Types

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
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
Parameter NameSQL textValidation
Source
mtst.user_defined_flag=decode(:source,'S','N','Y')
LOV
Show DFF Attributes
select xxen_util.dff_columns(p_table_name=>'mtl_txn_source_types') sql_text from dual
LOV
Download
Related Blitz Reports
INV Transaction Historical Summary ECC Process Genealogy and Trace, Lot Numbers CAC WIP Jobs With Complete Status Which Are Ready for Close MAD1 CSE Bill of Lading CAC AP Accrual IR ISO Match Analysis TB GL Account Analysis (Drilldown)v2 ECC Process Genealogy and Trace, Serial Numbers CAC Internal Order Shipment Margin ECC Genealogy and Trace, Serial Numbers
Blitz Report™