VIEW: APPS.PAY_BALANCE_DEFINED_DIMENSIONS

Source

View Text - Preformatted

SELECT (BTTL.BALANCE_NAME || BM.DATABASE_ITEM_SUFFIX) , BD.DEFINED_BALANCE_ID , BT.BALANCE_TYPE_ID , BM.BALANCE_DIMENSION_ID , DECODE(ALB.DEFINED_BALANCE_ID, NULL, DECODE(PLB.DEFINED_BALANCE_ID, NULL, 'N', 'Y'), 'Y') FROM PAY_BALANCE_TYPES_TL BTTL , PAY_BALANCE_TYPES BT , PAY_DEFINED_BALANCES BD , PAY_BALANCE_DIMENSIONS BM , PAY_ASSIGNMENT_LATEST_BALANCES ALB , PAY_PERSON_LATEST_BALANCES PLB WHERE BT.balance_type_id = BTTL.balance_type_id AND BTTL.LANGUAGE = userenv('LANG') AND BT.BALANCE_TYPE_ID = BD.BALANCE_TYPE_ID AND BD.BALANCE_DIMENSION_ID = BM.BALANCE_DIMENSION_ID AND BD.DEFINED_BALANCE_ID = ALB.DEFINED_BALANCE_ID (+) AND BD.DEFINED_BALANCE_ID = PLB.DEFINED_BALANCE_ID (+)

View Text - HTML Formatted

SELECT (BTTL.BALANCE_NAME || BM.DATABASE_ITEM_SUFFIX)
, BD.DEFINED_BALANCE_ID
, BT.BALANCE_TYPE_ID
, BM.BALANCE_DIMENSION_ID
, DECODE(ALB.DEFINED_BALANCE_ID
, NULL
, DECODE(PLB.DEFINED_BALANCE_ID
, NULL
, 'N'
, 'Y')
, 'Y')
FROM PAY_BALANCE_TYPES_TL BTTL
, PAY_BALANCE_TYPES BT
, PAY_DEFINED_BALANCES BD
, PAY_BALANCE_DIMENSIONS BM
, PAY_ASSIGNMENT_LATEST_BALANCES ALB
, PAY_PERSON_LATEST_BALANCES PLB
WHERE BT.BALANCE_TYPE_ID = BTTL.BALANCE_TYPE_ID
AND BTTL.LANGUAGE = USERENV('LANG')
AND BT.BALANCE_TYPE_ID = BD.BALANCE_TYPE_ID
AND BD.BALANCE_DIMENSION_ID = BM.BALANCE_DIMENSION_ID
AND BD.DEFINED_BALANCE_ID = ALB.DEFINED_BALANCE_ID (+)
AND BD.DEFINED_BALANCE_ID = PLB.DEFINED_BALANCE_ID (+)