View: MTL_STAT_TYPE_USAGES_V

Product:	INV - Inventory
Description:	Join of Stat_Type_Usages, Hr Legal Entities, Category Sets, Economic Zones View and Hr Locations
Implementation/DBA Data:	APPS.MTL_STAT_TYPE_USAGES_V

View Text

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

Columns