VIEW: APPS.PAY_BALANCE_TYPES_V

Source

View Text - Preformatted

SELECT BT.ROWID ROW_ID , BT.BALANCE_TYPE_ID , BT.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , BT.LEGISLATION_CODE , BT.CURRENCY_CODE , BT.ASSIGNMENT_REMUNERATION_FLAG , BTTL.BALANCE_NAME , BT.BALANCE_NAME base_balance_name , BT.BALANCE_UOM , BT.COMMENTS , BT.LEGISLATION_SUBGROUP , BTTL.REPORTING_NAME , BT.ATTRIBUTE_CATEGORY , BT.ATTRIBUTE1 , BT.ATTRIBUTE2 , BT.ATTRIBUTE3 , BT.ATTRIBUTE4 , BT.ATTRIBUTE5 , BT.ATTRIBUTE6 , BT.ATTRIBUTE7 , BT.ATTRIBUTE8 , BT.ATTRIBUTE9 , BT.ATTRIBUTE10 , BT.ATTRIBUTE11 , BT.ATTRIBUTE12 , BT.ATTRIBUTE13 , BT.ATTRIBUTE14 , BT.ATTRIBUTE15 , BT.ATTRIBUTE16 , BT.ATTRIBUTE17 , BT.ATTRIBUTE18 , BT.ATTRIBUTE19 , BT.ATTRIBUTE20 , BT.LAST_UPDATE_DATE , BT.LAST_UPDATED_BY , BT.LAST_UPDATE_LOGIN , BT.CREATED_BY , BT.CREATION_DATE , HL.MEANING UNITS , BT.BALANCE_CATEGORY_ID , PBC.CATEGORY_NAME , BT.BASE_BALANCE_TYPE_ID , BASE_BTTL.BALANCE_NAME BASE_BALANCE , BT.INPUT_VALUE_ID PRIMARY_BAL_IV_ID , PIVTL.NAME PRIMARY_BAL_IV_NAME , PET.ELEMENT_TYPE_ID PRIMARY_BAL_ELE_ID , PETTL.ELEMENT_NAME PRIMARY_BAL_ELE_NAME , PBC.USER_CATEGORY_NAME , BCT.USER_CATEGORY_NAME TL_USER_CATEGORY_NAME FROM PAY_BALANCE_TYPES BT , PAY_BALANCE_TYPES_TL BTTL , HR_LOOKUPS HL , PAY_BALANCE_CATEGORIES_F PBC , PAY_BALANCE_CATEGORIES_F_TL BCT , FND_SESSIONS FS , PAY_BALANCE_TYPES BASE_BT , PAY_BALANCE_TYPES_TL BASE_BTTL , PAY_ELEMENT_TYPES_F PET , PAY_ELEMENT_TYPES_F_TL PETTL , PAY_INPUT_VALUES_F PIV , PAY_INPUT_VALUES_F_TL PIVTL WHERE BT.BALANCE_TYPE_ID = BTTL.BALANCE_TYPE_ID AND BTTL.LANGUAGE = userenv('LANG') AND HL.LOOKUP_TYPE = 'UNITS' AND HL.LOOKUP_CODE = BT.BALANCE_UOM AND BT.BALANCE_CATEGORY_ID = PBC.BALANCE_CATEGORY_ID (+) AND BT.BALANCE_CATEGORY_ID = BCT.BALANCE_CATEGORY_ID(+) AND nvl(BCT.LANGUAGE,USERENV('lang')) = USERENV('lang') AND FS.SESSION_ID = USERENV('SESSIONID') AND FS.EFFECTIVE_DATE BETWEEN NVL(PBC.EFFECTIVE_START_DATE ,FND_DATE.CANONICAL_TO_DATE('0001/01/01')) AND NVL(PBC.EFFECTIVE_END_DATE ,FND_DATE.CANONICAL_TO_DATE('4712/12/31')) AND BT.BASE_BALANCE_TYPE_ID = BASE_BT.BALANCE_TYPE_ID (+) AND BASE_BT.BALANCE_TYPE_ID = BASE_BTTL.BALANCE_TYPE_ID (+) AND NVL(BASE_BTTL.LANGUAGE, USERENV('LANG')) = userenv('LANG') AND BT.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID (+) AND PIV.INPUT_VALUE_ID = PIVTL.INPUT_VALUE_ID (+) AND NVL(PIVTL.LANGUAGE, USERENV('LANG')) = USERENV('LANG') AND FS.EFFECTIVE_DATE BETWEEN NVL(PIV.EFFECTIVE_START_DATE ,FND_DATE.CANONICAL_TO_DATE('0001/01/01')) AND NVL(PIV.EFFECTIVE_END_DATE ,FND_DATE.CANONICAL_TO_DATE('4712/12/31')) AND PET.ELEMENT_TYPE_ID (+) = PIV.ELEMENT_TYPE_ID AND PET.ELEMENT_TYPE_ID = PETTL.ELEMENT_TYPE_ID (+) AND NVL(PETTL.LANGUAGE, USERENV('LANG')) = userenv('LANG') AND FS.EFFECTIVE_DATE BETWEEN NVL(PET.EFFECTIVE_START_DATE ,FND_DATE.CANONICAL_TO_DATE('0001/01/01')) AND NVL(PET.EFFECTIVE_END_DATE ,FND_DATE.CANONICAL_TO_DATE('4712/12/31'))

View Text - HTML Formatted

SELECT BT.ROWID ROW_ID
, BT.BALANCE_TYPE_ID
, BT.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, BT.LEGISLATION_CODE
, BT.CURRENCY_CODE
, BT.ASSIGNMENT_REMUNERATION_FLAG
, BTTL.BALANCE_NAME
, BT.BALANCE_NAME BASE_BALANCE_NAME
, BT.BALANCE_UOM
, BT.COMMENTS
, BT.LEGISLATION_SUBGROUP
, BTTL.REPORTING_NAME
, BT.ATTRIBUTE_CATEGORY
, BT.ATTRIBUTE1
, BT.ATTRIBUTE2
, BT.ATTRIBUTE3
, BT.ATTRIBUTE4
, BT.ATTRIBUTE5
, BT.ATTRIBUTE6
, BT.ATTRIBUTE7
, BT.ATTRIBUTE8
, BT.ATTRIBUTE9
, BT.ATTRIBUTE10
, BT.ATTRIBUTE11
, BT.ATTRIBUTE12
, BT.ATTRIBUTE13
, BT.ATTRIBUTE14
, BT.ATTRIBUTE15
, BT.ATTRIBUTE16
, BT.ATTRIBUTE17
, BT.ATTRIBUTE18
, BT.ATTRIBUTE19
, BT.ATTRIBUTE20
, BT.LAST_UPDATE_DATE
, BT.LAST_UPDATED_BY
, BT.LAST_UPDATE_LOGIN
, BT.CREATED_BY
, BT.CREATION_DATE
, HL.MEANING UNITS
, BT.BALANCE_CATEGORY_ID
, PBC.CATEGORY_NAME
, BT.BASE_BALANCE_TYPE_ID
, BASE_BTTL.BALANCE_NAME BASE_BALANCE
, BT.INPUT_VALUE_ID PRIMARY_BAL_IV_ID
, PIVTL.NAME PRIMARY_BAL_IV_NAME
, PET.ELEMENT_TYPE_ID PRIMARY_BAL_ELE_ID
, PETTL.ELEMENT_NAME PRIMARY_BAL_ELE_NAME
, PBC.USER_CATEGORY_NAME
, BCT.USER_CATEGORY_NAME TL_USER_CATEGORY_NAME
FROM PAY_BALANCE_TYPES BT
, PAY_BALANCE_TYPES_TL BTTL
, HR_LOOKUPS HL
, PAY_BALANCE_CATEGORIES_F PBC
, PAY_BALANCE_CATEGORIES_F_TL BCT
, FND_SESSIONS FS
, PAY_BALANCE_TYPES BASE_BT
, PAY_BALANCE_TYPES_TL BASE_BTTL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_INPUT_VALUES_F PIV
, PAY_INPUT_VALUES_F_TL PIVTL
WHERE BT.BALANCE_TYPE_ID = BTTL.BALANCE_TYPE_ID
AND BTTL.LANGUAGE = USERENV('LANG')
AND HL.LOOKUP_TYPE = 'UNITS'
AND HL.LOOKUP_CODE = BT.BALANCE_UOM
AND BT.BALANCE_CATEGORY_ID = PBC.BALANCE_CATEGORY_ID (+)
AND BT.BALANCE_CATEGORY_ID = BCT.BALANCE_CATEGORY_ID(+)
AND NVL(BCT.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN NVL(PBC.EFFECTIVE_START_DATE
, FND_DATE.CANONICAL_TO_DATE('0001/01/01'))
AND NVL(PBC.EFFECTIVE_END_DATE
, FND_DATE.CANONICAL_TO_DATE('4712/12/31'))
AND BT.BASE_BALANCE_TYPE_ID = BASE_BT.BALANCE_TYPE_ID (+)
AND BASE_BT.BALANCE_TYPE_ID = BASE_BTTL.BALANCE_TYPE_ID (+)
AND NVL(BASE_BTTL.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND BT.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID (+)
AND PIV.INPUT_VALUE_ID = PIVTL.INPUT_VALUE_ID (+)
AND NVL(PIVTL.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND FS.EFFECTIVE_DATE BETWEEN NVL(PIV.EFFECTIVE_START_DATE
, FND_DATE.CANONICAL_TO_DATE('0001/01/01'))
AND NVL(PIV.EFFECTIVE_END_DATE
, FND_DATE.CANONICAL_TO_DATE('4712/12/31'))
AND PET.ELEMENT_TYPE_ID (+) = PIV.ELEMENT_TYPE_ID
AND PET.ELEMENT_TYPE_ID = PETTL.ELEMENT_TYPE_ID (+)
AND NVL(PETTL.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND FS.EFFECTIVE_DATE BETWEEN NVL(PET.EFFECTIVE_START_DATE
, FND_DATE.CANONICAL_TO_DATE('0001/01/01'))
AND NVL(PET.EFFECTIVE_END_DATE
, FND_DATE.CANONICAL_TO_DATE('4712/12/31'))