[Home] [Help]
View: PSBFV_DEFAULT_DISTRIBUTIONS
View Text
SELECT PD.NAME
, '_KF:SQLGL:GL#:GCC'
, PDR.DISTRIBUTION_PERCENT
, PDR.ACCOUNT_DISTRIBUTION_ID
, PDR.CODE_COMBINATION_ID
, PDR.DEFAULT_RULE_ID
, PDR.LAST_UPDATE_DATE
, PDR.LAST_UPDATED_BY
, PDR.CREATED_BY
, PDR.CREATION_DATE
FROM PSB_DEFAULT_ACCOUNT_DISTRS PDR
, PSB_DEFAULTS PD
, GL_CODE_COMBINATIONS_KFV GCC
WHERE PDR.DEFAULT_RULE_ID = PD.DEFAULT_RULE_ID
AND PDR.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY
Columns
Name |
DEFAULT_RULE_NAME |
"_KF:GL_ACCOUNT" |
DISTRIBUTION_PERCENT |
ACCOUNT_DISTRIBUTION_ID |
CODE_COMBINATION_ID |
DEFAULT_RULE_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |