PAY_DIR_CARD_COMP_DEFS

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
DIR_CARD_COMP_DEF_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE DIR_CARD_DEFINITION_ID DEDUCTION_TYPE_ID DEDUCTION_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID LEGISLATIVE_DATA_GROUP_ID DEFAULTING_TRU_COMP_FLAG BREAKDOWN_COMPONENT_FLAG KEEP_OPEN GLB_TRANSFER_RULE ELEMENT_TYPE_ID REQUIRED MULTIPLE_ALLOWED BASE_COMPONENT_NAME COMPONENT_NAME OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN ASSOCIABLE_TRU ASSOCIABLE_TERM SEED_STATUS SGUID

Name

DIR_CARD_COMP_DEF_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

DIR_CARD_DEFINITION_ID

DEDUCTION_TYPE_ID

DEDUCTION_GROUP_ID

LEGISLATION_CODE

ENTERPRISE_ID

LEGISLATIVE_DATA_GROUP_ID

DEFAULTING_TRU_COMP_FLAG

BREAKDOWN_COMPONENT_FLAG

KEEP_OPEN

GLB_TRANSFER_RULE

ELEMENT_TYPE_ID

REQUIRED

MULTIPLE_ALLOWED

BASE_COMPONENT_NAME

COMPONENT_NAME

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

ASSOCIABLE_TRU

ASSOCIABLE_TERM

SEED_STATUS

SGUID

Query

SQL_Statement
SELECT pdccdf.DIR_CARD_COMP_DEF_ID DIR_CARD_COMP_DEF_ID, pdccdf.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, pdccdf.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, pdccdf.DIR_CARD_DEFINITION_ID DIR_CARD_DEFINITION_ID, pdccdf.DEDUCTION_TYPE_ID DEDUCTION_TYPE_ID, pdccdf.DEDUCTION_GROUP_ID DEDUCTION_GROUP_ID, pdccdf.LEGISLATION_CODE LEGISLATION_CODE, pdccdf.ENTERPRISE_ID ENTERPRISE_ID, pdccdf.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, pdccdf.DEFAULTING_TRU_COMP_FLAG DEFAULTING_TRU_COMP_FLAG, pdccdf.BREAKDOWN_COMPONENT_FLAG BREAKDOWN_COMPONENT_FLAG, pdccdf.KEEP_OPEN KEEP_OPEN, pdccdf.GLB_TRANSFER_RULE GLB_TRANSFER_RULE, pdccdf.ELEMENT_TYPE_ID ELEMENT_TYPE_ID, pdccdf.REQUIRED REQUIRED, pdccdf.MULTIPLE_ALLOWED MULTIPLE_ALLOWED, pdccdf.BASE_COMPONENT_NAME BASE_COMPONENT_NAME, pdccdtl.COMPONENT_NAME COMPONENT_NAME, pdccdf.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pdccdf.CREATED_BY CREATED_BY, pdccdf.CREATION_DATE CREATION_DATE, pdccdf.LAST_UPDATE_DATE LAST_UPDATE_DATE, pdccdf.LAST_UPDATED_BY LAST_UPDATED_BY, pdccdf.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pdccdf.ASSOCIABLE_TRU ASSOCIABLE_TRU, pdccdf.ASSOCIABLE_TERM ASSOCIABLE_TERM, pdccdf.SEED_STATUS SEED_STATUS, pdccdf.SGUID SGUID FROM PAY_DIR_CARD_COMP_DEFS_F pdccdf, PAY_DIR_CARD_COMP_DEFS_TL pdccdtl WHERE pdccdf.DIR_CARD_COMP_DEF_ID = pdccdtl.DIR_CARD_COMP_DEF_ID AND pdccdtl.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

pdccdf.DIR_CARD_COMP_DEF_ID DIR_CARD_COMP_DEF_ID,

pdccdf.EFFECTIVE_START_DATE EFFECTIVE_START_DATE,

pdccdf.EFFECTIVE_END_DATE EFFECTIVE_END_DATE,

pdccdf.DIR_CARD_DEFINITION_ID DIR_CARD_DEFINITION_ID,

pdccdf.DEDUCTION_TYPE_ID DEDUCTION_TYPE_ID,

pdccdf.DEDUCTION_GROUP_ID DEDUCTION_GROUP_ID,

pdccdf.LEGISLATION_CODE LEGISLATION_CODE,

pdccdf.ENTERPRISE_ID ENTERPRISE_ID,

pdccdf.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,

pdccdf.DEFAULTING_TRU_COMP_FLAG DEFAULTING_TRU_COMP_FLAG,

pdccdf.BREAKDOWN_COMPONENT_FLAG BREAKDOWN_COMPONENT_FLAG,

pdccdf.KEEP_OPEN KEEP_OPEN,

pdccdf.GLB_TRANSFER_RULE GLB_TRANSFER_RULE,

pdccdf.ELEMENT_TYPE_ID ELEMENT_TYPE_ID,

pdccdf.REQUIRED REQUIRED,

pdccdf.MULTIPLE_ALLOWED MULTIPLE_ALLOWED,

pdccdf.BASE_COMPONENT_NAME BASE_COMPONENT_NAME,

pdccdtl.COMPONENT_NAME COMPONENT_NAME,

pdccdf.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

pdccdf.CREATED_BY CREATED_BY,

pdccdf.CREATION_DATE CREATION_DATE,

pdccdf.LAST_UPDATE_DATE LAST_UPDATE_DATE,

pdccdf.LAST_UPDATED_BY LAST_UPDATED_BY,

pdccdf.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

pdccdf.ASSOCIABLE_TRU ASSOCIABLE_TRU,

pdccdf.ASSOCIABLE_TERM ASSOCIABLE_TERM,

pdccdf.SEED_STATUS SEED_STATUS,

pdccdf.SGUID SGUID

FROM

PAY_DIR_CARD_COMP_DEFS_F pdccdf,

PAY_DIR_CARD_COMP_DEFS_TL pdccdtl

WHERE

pdccdf.DIR_CARD_COMP_DEF_ID = pdccdtl.DIR_CARD_COMP_DEF_ID AND pdccdtl.LANGUAGE = USERENV('LANG')