Product: | GL - General Ledger |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GL_BUDORG_BC_OPTIONS_V |
SELECT BCO.ROWID ROW_ID
, BCO.RANGE_ID RANGE_ID
, BCO.FUNDS_CHECK_LEVEL_CODE FUNDS_CHECK_LEVEL_CODE
, BCO.AMOUNT_TYPE AMOUNT_TYPE
, L.MEANING SHOW_AMOUNT_TYPE
, BCO.BOUNDARY_CODE BOUNDARY_CODE
, L2.MEANING SHOW_BOUNDARY
, BCO.FUNDING_BUDGET_VERSION_ID FUNDING_BUDGET_VERSION_ID
, BV.BUDGET_NAME FUNDING_BUDGET_NAME
, BCO.CREATION_DATE CREATION_DATE
, BCO.CREATED_BY CREATED_BY
, BCO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BCO.LAST_UPDATED_BY LAST_UPDATED_BY
, BCO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM GL_BUDORG_BC_OPTIONS BCO
, GL_BUDGET_VERSIONS BV
, GL_LOOKUPS L
, GL_LOOKUPS L2
WHERE BV.BUDGET_VERSION_ID(+) = BCO.FUNDING_BUDGET_VERSION_ID AND L.LOOKUP_TYPE(+) = 'PTD_YTD' AND L.LOOKUP_CODE(+) = BCO.AMOUNT_TYPE AND L2.LOOKUP_TYPE(+) = 'BOUNDARY_TYPE' AND L2.LOOKUP_CODE(+) = BCO.BOUNDARY_CODE