PAY_DIR_CARD_DEFINITIONS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name
DIR_CARD_DEFINITION_ID BASE_DISPLAY_NAME LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID DISPLAY_NAME OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN AUTO_GENERATE ASSOCIABLE_TRU ASSOCIABLE_TERM DESCRIPTION MODULE_ID BREAKDOWN_COMPONENT_FLAG KEEP_OPEN GLB_TRANSFER_RULE DATE_MODE DEFAULTING_TRU_FLAG VO_NAME SEED_STATUS USER_EXTENSIBLE_FLAG

Query

SQL_Statement

SELECT pdcd.DIR_CARD_DEFINITION_ID DIR_CARD_DEFINITION_ID, pdcd.BASE_DISPLAY_NAME BASE_DISPLAY_NAME, pdcd.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, pdcd.LEGISLATION_CODE LEGISLATION_CODE, pdcd.ENTERPRISE_ID ENTERPRISE_ID, pdcdtl.DISPLAY_NAME DISPLAY_NAME, pdcd.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pdcd.CREATED_BY CREATED_BY, pdcd.CREATION_DATE CREATION_DATE, pdcd.LAST_UPDATE_DATE LAST_UPDATE_DATE, pdcd.LAST_UPDATED_BY LAST_UPDATED_BY, pdcd.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pdcd.AUTO_GENERATE AUTO_GENERATE, pdcd.ASSOCIABLE_TRU ASSOCIABLE_TRU, pdcd.ASSOCIABLE_TERM ASSOCIABLE_TERM, pdcdtl.DESCRIPTION DESCRIPTION, pdcd.MODULE_ID MODULE_ID, pdcd.BREAKDOWN_COMPONENT_FLAG BREAKDOWN_COMPONENT_FLAG, pdcd.KEEP_OPEN, pdcd.GLB_TRANSFER_RULE GLB_TRANSFER_RULE, pdcd.DATE_MODE DATE_MODE, pdcd.DEFAULTING_TRU_FLAG DEFAULTING_TRU_FLAG, pdcd.VO_NAME VO_NAME, pdcd.SEED_STATUS SEED_STATUS, pdcd.USER_EXTENSIBLE_FLAG FROM PAY_DIR_CARD_DEFINITIONS pdcd, PAY_DIR_CARD_DEFINITIONS_TL pdcdtl WHERE pdcd.DIR_CARD_DEFINITION_ID = pdcdtl.DIR_CARD_DEFINITION_ID AND pdcdtl.LANGUAGE = USERENV('LANG')