VIEW: APPS.MTL_STAT_TYPE_USAGES_V

Source

View Text - Preformatted

SELECT sta.Rowid Row_ID , sta.Legal_Entity_ID , sta.Zone_Code , sta.Stat_Type , sta.Usage_Type , sta.Creation_Date , sta.Created_By , sta.Last_Update_Date , sta.Last_Updated_By , sta.Last_Update_Login , xfiv.Name , ezv.Zone_Display_Name , sta.Period_Set_Name , sta.period_type , gpt.user_period_type , sta.Start_period_name , sta.End_period_name , sta.Weight_UOM_Code , sta.Entity_Branch_Reference , sta.Conversion_Type , sta.Conversion_Option , sta.Category_Set_ID , cat.Category_Set_Name , sta.Tax_Office_Code , sta.Tax_Office_Name , sta.Tax_Office_Location_ID , loc.Location_Code Tax_Office_Location_Code , sta.attribute_rule_set_code ,sta.alt_uom_rule_set_code ,sta.triangulation_mode ,sta.reference_period_rule ,sta.pending_invoice_days ,sta.prior_invoice_days ,sta.returns_processing ,sta.kit_method ,sta.weight_precision ,sta.reporting_rounding , sta.include_establishments from mtl_stat_type_usages sta , xle_firstparty_information_v xfiv , gl_period_types gpt , mtl_category_sets cat , mtl_economic_zones_vl ezv , hr_locations loc where sta.Legal_Entity_ID = xfiv.legal_entity_ID and gpt.period_type = sta.period_type and sta.Category_Set_ID = cat.Category_Set_ID and sta.Zone_Code = ezv.Zone_Code and sta.Tax_Office_Location_ID = loc.Location_ID UNION select sta.Rowid Row_ID , sta.Legal_Entity_ID , sta.Zone_Code , sta.Stat_Type , sta.Usage_Type , sta.Creation_Date , sta.Created_By , sta.Last_Update_Date , sta.Last_Updated_By , sta.Last_Update_Login , xfiv.Name , ezv.Zone_Display_Name , sta.Period_Set_Name , sta.period_type , gpt.user_period_type , sta.Start_period_name , sta.End_period_name , sta.Weight_UOM_Code , sta.Entity_Branch_Reference , sta.Conversion_Type , sta.Conversion_Option , sta.Category_Set_ID , cat.Category_Set_Name , sta.Tax_Office_Code , sta.Tax_Office_Name , sta.Tax_Office_Location_ID , substr(hzl.city,1,10)||substr(hzl.location_id,1,10) Tax_Office_Location_Code , sta.attribute_rule_set_code ,sta.alt_uom_rule_set_code ,sta.triangulation_mode ,sta.reference_period_rule ,sta.pending_invoice_days ,sta.prior_invoice_days ,sta.returns_processing ,sta.kit_method ,sta.weight_precision ,sta.reporting_rounding , sta.include_establishments from mtl_stat_type_usages sta , xle_firstparty_information_v xfiv , gl_period_types gpt , mtl_category_sets cat , mtl_economic_zones_vl ezv , hz_locations hzl WHERE sta.Legal_Entity_ID = xfiv.legal_entity_ID and gpt.period_type = sta.period_type and sta.Category_Set_ID = cat.Category_Set_ID and sta.Zone_Code = ezv.Zone_Code and sta.Tax_Office_Location_ID = hzl.Location_ID

View Text - HTML Formatted

SELECT STA.ROWID ROW_ID
, STA.LEGAL_ENTITY_ID
, STA.ZONE_CODE
, STA.STAT_TYPE
, STA.USAGE_TYPE
, STA.CREATION_DATE
, STA.CREATED_BY
, STA.LAST_UPDATE_DATE
, STA.LAST_UPDATED_BY
, STA.LAST_UPDATE_LOGIN
, XFIV.NAME
, EZV.ZONE_DISPLAY_NAME
, STA.PERIOD_SET_NAME
, STA.PERIOD_TYPE
, GPT.USER_PERIOD_TYPE
, STA.START_PERIOD_NAME
, STA.END_PERIOD_NAME
, STA.WEIGHT_UOM_CODE
, STA.ENTITY_BRANCH_REFERENCE
, STA.CONVERSION_TYPE
, STA.CONVERSION_OPTION
, STA.CATEGORY_SET_ID
, CAT.CATEGORY_SET_NAME
, STA.TAX_OFFICE_CODE
, STA.TAX_OFFICE_NAME
, STA.TAX_OFFICE_LOCATION_ID
, LOC.LOCATION_CODE TAX_OFFICE_LOCATION_CODE
, STA.ATTRIBUTE_RULE_SET_CODE
, STA.ALT_UOM_RULE_SET_CODE
, STA.TRIANGULATION_MODE
, STA.REFERENCE_PERIOD_RULE
, STA.PENDING_INVOICE_DAYS
, STA.PRIOR_INVOICE_DAYS
, STA.RETURNS_PROCESSING
, STA.KIT_METHOD
, STA.WEIGHT_PRECISION
, STA.REPORTING_ROUNDING
, STA.INCLUDE_ESTABLISHMENTS
FROM MTL_STAT_TYPE_USAGES STA
, XLE_FIRSTPARTY_INFORMATION_V XFIV
, GL_PERIOD_TYPES GPT
, MTL_CATEGORY_SETS CAT
, MTL_ECONOMIC_ZONES_VL EZV
, HR_LOCATIONS LOC
WHERE STA.LEGAL_ENTITY_ID = XFIV.LEGAL_ENTITY_ID
AND GPT.PERIOD_TYPE = STA.PERIOD_TYPE
AND STA.CATEGORY_SET_ID = CAT.CATEGORY_SET_ID
AND STA.ZONE_CODE = EZV.ZONE_CODE
AND STA.TAX_OFFICE_LOCATION_ID = LOC.LOCATION_ID UNION SELECT STA.ROWID ROW_ID
, STA.LEGAL_ENTITY_ID
, STA.ZONE_CODE
, STA.STAT_TYPE
, STA.USAGE_TYPE
, STA.CREATION_DATE
, STA.CREATED_BY
, STA.LAST_UPDATE_DATE
, STA.LAST_UPDATED_BY
, STA.LAST_UPDATE_LOGIN
, XFIV.NAME
, EZV.ZONE_DISPLAY_NAME
, STA.PERIOD_SET_NAME
, STA.PERIOD_TYPE
, GPT.USER_PERIOD_TYPE
, STA.START_PERIOD_NAME
, STA.END_PERIOD_NAME
, STA.WEIGHT_UOM_CODE
, STA.ENTITY_BRANCH_REFERENCE
, STA.CONVERSION_TYPE
, STA.CONVERSION_OPTION
, STA.CATEGORY_SET_ID
, CAT.CATEGORY_SET_NAME
, STA.TAX_OFFICE_CODE
, STA.TAX_OFFICE_NAME
, STA.TAX_OFFICE_LOCATION_ID
, SUBSTR(HZL.CITY
, 1
, 10)||SUBSTR(HZL.LOCATION_ID
, 1
, 10) TAX_OFFICE_LOCATION_CODE
, STA.ATTRIBUTE_RULE_SET_CODE
, STA.ALT_UOM_RULE_SET_CODE
, STA.TRIANGULATION_MODE
, STA.REFERENCE_PERIOD_RULE
, STA.PENDING_INVOICE_DAYS
, STA.PRIOR_INVOICE_DAYS
, STA.RETURNS_PROCESSING
, STA.KIT_METHOD
, STA.WEIGHT_PRECISION
, STA.REPORTING_ROUNDING
, STA.INCLUDE_ESTABLISHMENTS
FROM MTL_STAT_TYPE_USAGES STA
, XLE_FIRSTPARTY_INFORMATION_V XFIV
, GL_PERIOD_TYPES GPT
, MTL_CATEGORY_SETS CAT
, MTL_ECONOMIC_ZONES_VL EZV
, HZ_LOCATIONS HZL
WHERE STA.LEGAL_ENTITY_ID = XFIV.LEGAL_ENTITY_ID
AND GPT.PERIOD_TYPE = STA.PERIOD_TYPE
AND STA.CATEGORY_SET_ID = CAT.CATEGORY_SET_ID
AND STA.ZONE_CODE = EZV.ZONE_CODE
AND STA.TAX_OFFICE_LOCATION_ID = HZL.LOCATION_ID