Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PPA.POSITION_ACCOUNT_LINE_ID
, PPA.POSITION_ID
, '_KF:PSB:BPS:PKFV:_CO'
, PPA.BUDGET_REVISION_ID
, BR.JUSTIFICATION
, PPA.BUDGET_GROUP_ID
, BG.SHORT_NAME
, PPA.BASE_LINE_VERSION
, PPA.START_DATE
, PPA.END_DATE
, PPA.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GCC'
, PPA.CURRENCY_CODE
, PPA.AMOUNT
FROM PSB_POSITION_ACCOUNTS PPA
, PSB_POSITIONS POS
, PSB_POSITION_DEFINITIONS_KFV PKFV
, PSB_BUDGET_REVISIONS BR
, PSB_BUDGET_GROUPS BG
, GL_CODE_COMBINATIONS GCC
WHERE PPA.POSITION_ID = POS.POSITION_ID
AND POS.POSITION_DEFINITION_ID = PKFV.POSITION_DEFINITION_ID
AND PPA.BUDGET_REVISION_ID = BR.BUDGET_REVISION_ID(+)
AND PPA.BUDGET_GROUP_ID = BG.BUDGET_GROUP_ID
AND GCC.CODE_COMBINATION_ID = PPA.CODE_COMBINATION_ID WITH READ ONLY