ZX_INPUT_CLASSIFICATIONS

Details

Schema: FUSION
Object owner: FND
Object type: VIEW

Columns

Name
SET_ID MEANING DESCRIPTION LOOKUP_CODE LOOKUP_TYPE ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE DISPLAY_SEQUENCE

Name

SET_ID

MEANING

DESCRIPTION

LOOKUP_CODE

LOOKUP_TYPE

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

DISPLAY_SEQUENCE

Query

SQL_Statement
SELECT LKV.set_id SET_ID, LKV.meaning MEANING, LKV.description DESCRIPTION, LKV.lookup_code LOOKUP_CODE, LKV.lookup_type LOOKUP_TYPE, LKV.enabled_flag ENABLED_FLAG, LKV.start_date_active START_DATE_ACTIVE, LKV.end_date_active END_DATE_ACTIVE, LKV.display_sequence DISPLAY_SEQUENCE FROM FND_LOOKUP_VALUES_VL LKV WHERE LKV.LOOKUP_TYPE = 'ZX_INPUT_CLASSIFICATIONS' AND LKV.enabled_flag = 'Y' AND LKV.view_application_id = 2 union SELECT LKVWEB.set_id SET_ID, nvl(LKVINP.meaning , LKVWEB.meaning) MEANING, nvl(LKVINP.description , LKVWEB.description) DESCRIPTION, LKVWEB.lookup_code LOOKUP_CODE, 'ZX_INPUT_CLASSIFICATIONS' LOOKUP_TYPE, nvl(LKVINP.enabled_flag,LKVWEB.enabled_flag) ENABLED_FLAG, nvl(LKVINP.start_date_active,LKVWEB.start_date_active) START_DATE_ACTIVE, nvl(LKVINP.end_date_active,LKVWEB.end_date_active) END_DATE_ACTIVE, LKVWEB.display_sequence DISPLAY_SEQUENCE FROM FND_LOOKUP_VALUES_VL LKVWEB, FND_LOOKUP_VALUES_VL LKVINP WHERE LKVWEB.LOOKUP_TYPE = 'ZX_WEB_EXP_TAX_CLASSIFICATIONS' AND LKVWEB.enabled_flag = 'Y' AND LKVWEB.view_application_id = 2 and LKVINP.LOOKUP_TYPE (+) = 'ZX_INPUT_CLASSIFICATIONS' AND LKVINP.enabled_flag (+)= LKVWEB.enabled_flag AND LKVINP.view_application_id(+) = 2 and LKVINP.lookup_code (+)= LKVWEB.lookup_code and LKVINP.set_id (+)= LKVWEB.set_id

SQL_Statement

SELECT

LKV.set_id SET_ID,

LKV.meaning MEANING,

LKV.description DESCRIPTION,

LKV.lookup_code LOOKUP_CODE,

LKV.lookup_type LOOKUP_TYPE,

LKV.enabled_flag ENABLED_FLAG,

LKV.start_date_active START_DATE_ACTIVE,

LKV.end_date_active END_DATE_ACTIVE,

LKV.display_sequence DISPLAY_SEQUENCE

FROM FND_LOOKUP_VALUES_VL LKV

WHERE LKV.LOOKUP_TYPE = 'ZX_INPUT_CLASSIFICATIONS'

AND LKV.enabled_flag = 'Y'

AND LKV.view_application_id = 2

union

SELECT

LKVWEB.set_id SET_ID,

nvl(LKVINP.meaning , LKVWEB.meaning) MEANING,

nvl(LKVINP.description , LKVWEB.description) DESCRIPTION,

LKVWEB.lookup_code LOOKUP_CODE,

'ZX_INPUT_CLASSIFICATIONS' LOOKUP_TYPE,

nvl(LKVINP.enabled_flag,LKVWEB.enabled_flag) ENABLED_FLAG,

nvl(LKVINP.start_date_active,LKVWEB.start_date_active)

START_DATE_ACTIVE,

nvl(LKVINP.end_date_active,LKVWEB.end_date_active) END_DATE_ACTIVE,

LKVWEB.display_sequence DISPLAY_SEQUENCE

FROM FND_LOOKUP_VALUES_VL LKVWEB, FND_LOOKUP_VALUES_VL LKVINP

WHERE LKVWEB.LOOKUP_TYPE = 'ZX_WEB_EXP_TAX_CLASSIFICATIONS'

AND LKVWEB.enabled_flag = 'Y'

AND LKVWEB.view_application_id = 2

and LKVINP.LOOKUP_TYPE (+) = 'ZX_INPUT_CLASSIFICATIONS'

AND LKVINP.enabled_flag (+)= LKVWEB.enabled_flag

AND LKVINP.view_application_id(+) = 2

and LKVINP.lookup_code (+)= LKVWEB.lookup_code

and LKVINP.set_id (+)= LKVWEB.set_id