View: PA_COST_DISTRIBUTION_LINES

View Text

SELECT EXPENDITURE_ITEM_ID
, LINE_NUM
, CREATION_DATE
, CREATED_BY
, TRANSFER_STATUS_CODE
, AMOUNT
, QUANTITY
, BILLABLE_FLAG
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, RESOURCE_ACCUMULATED_FLAG
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PA_DATE
, RECVR_PA_DATE
, DR_CODE_COMBINATION_ID
, GL_DATE
, RECVR_GL_DATE
, TRANSFERRED_DATE
, TRANSFER_REJECTION_REASON
, BATCH_NAME
, ACCUMULATED_FLAG
, REVERSED_FLAG
, LINE_NUM_REVERSED
, SYSTEM_REFERENCE1
, SYSTEM_REFERENCE2
, SYSTEM_REFERENCE3
, CR_CODE_COMBINATION_ID
, IND_COMPILED_SET_ID
, LINE_TYPE
, BURDENED_COST
, ORG_ID
, BURDEN_SUM_SOURCE_RUN_ID
, BURDEN_SUM_REJECTION_CODE
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, PROJECT_ID
, TASK_ID
, PRC_GENERATED_FLAG
, UTIL_SUMMARIZED_FLAG
, PJI_SUMMARIZED_FLAG
, LIQUIDATE_ENCUM_FLAG
, ENCUMBRANCE_BATCH_NAME
, ENCUMBRANCE_TYPE_ID
, ENCUMBRANCE_AMOUNT
, BUDGET_CCID
, ENCUM_TRANSFER_REJ_REASON
, GL_PERIOD_NAME
, RECVR_GL_PERIOD_NAME
, PA_PERIOD_NAME
, RECVR_PA_PERIOD_NAME
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_EXCHANGE_RATE
, PROJECT_RAW_COST
, PROJECT_BURDENED_COST
, WORK_TYPE_ID
, SYSTEM_REFERENCE4
, ORG_LABOR_SCH_RULE_ID
, COST_RATE_SCH_ID
, DENOM_BURDENED_CHANGE
, PROJECT_BURDENED_CHANGE
, PROJFUNC_BURDENED_CHANGE
, ACCT_BURDENED_CHANGE
, PARENT_LINE_NUM
, PREV_IND_COMPILED_SET_ID
FROM PA_COST_DISTRIBUTION_LINES_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns