VIEW: APPS.PSBFV_POSITION_ACCOUNTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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