ZX_FC_PRODUCT_FISCAL_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
CLASSIFICATION_ID CLASSIFICATION_CODE CATEGORY_NAME CLASSIFICATION_NAME DESCRIPTION COUNTRY_CODE EFFECTIVE_TO CATEGORY_ID STRUCTURE_ID CATEGORY_SET_ID STRUCTURE_NAME STRUCTURE_CODE

Query

SQL_Statement

SELECT MC.CATEGORY_ID CLASSIFICATION_ID, MC.CATEGORY_CODE CLASSIFICATION_CODE, MCT.CATEGORY_NAME CATEGORY_NAME, MCT.CATEGORY_NAME CLASSIFICATION_NAME, MCT.DESCRIPTION DESCRIPTION, ZCD.COUNTRY_CODE COUNTRY_CODE, MC.END_DATE_ACTIVE EFFECTIVE_TO, MC.CATEGORY_ID CATEGORY_ID, MC.STRUCTURE_INSTANCE_NUMBER STRUCTURE_ID, MCS.CATEGORY_SET_ID CATEGORY_SET_ID, '' STRUCTURE_NAME, '' STRUCTURE_CODE FROM ZX_FC_COUNTRY_DEFAULTS ZCD, EGP_CATEGORY_SETS_B MCS, EGP_CATEGORIES_TL MCT , EGP_CATEGORIES_B MC, EGP_CATEGORY_SET_VALID_CATS MCSV WHERE MCS.CATEGORY_SET_ID = ZCD.PRIMARY_INVENTORY_CATEGORY_SET AND MC.CATEGORY_ID = MCT.CATEGORY_ID AND MCT.LANGUAGE = USERENV ( 'LANG') AND MC.ENABLED_FLAG = 'Y' AND MCSV.CATEGORY_ID = MC.CATEGORY_ID AND MCSV.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID