VIEW: APPS.PAY_INPUT_VALUES_F_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.INPUT_VALUE_ID, B.EFFECTIVE_START_DATE, B.EFFECTIVE_END_DATE, B.ELEMENT_TYPE_ID, B.LOOKUP_TYPE, B.BUSINESS_GROUP_ID, B.LEGISLATION_CODE, B.FORMULA_ID, B.DISPLAY_SEQUENCE, B.GENERATE_DB_ITEMS_FLAG, B.HOT_DEFAULT_FLAG, B.MANDATORY_FLAG, T.NAME, B.UOM, B.DEFAULT_VALUE, B.LEGISLATION_SUBGROUP, B.MAX_VALUE, B.MIN_VALUE, B.WARNING_OR_ERROR, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.CREATED_BY, B.CREATION_DATE, B.OBJECT_VERSION_NUMBER, B.VALUE_SET_ID FROM PAY_INPUT_VALUES_F B, PAY_INPUT_VALUES_F_TL T WHERE B.INPUT_VALUE_ID = T.INPUT_VALUE_ID AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.INPUT_VALUE_ID
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.ELEMENT_TYPE_ID
, B.LOOKUP_TYPE
, B.BUSINESS_GROUP_ID
, B.LEGISLATION_CODE
, B.FORMULA_ID
, B.DISPLAY_SEQUENCE
, B.GENERATE_DB_ITEMS_FLAG
, B.HOT_DEFAULT_FLAG
, B.MANDATORY_FLAG
, T.NAME
, B.UOM
, B.DEFAULT_VALUE
, B.LEGISLATION_SUBGROUP
, B.MAX_VALUE
, B.MIN_VALUE
, B.WARNING_OR_ERROR
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.OBJECT_VERSION_NUMBER
, B.VALUE_SET_ID
FROM PAY_INPUT_VALUES_F B
, PAY_INPUT_VALUES_F_TL T
WHERE B.INPUT_VALUE_ID = T.INPUT_VALUE_ID
AND T.LANGUAGE = USERENV('LANG')