Product: | PA - Projects |
---|---|
Description: | Single-Org |
Implementation/DBA Data: | Not implemented in this database |
SELECT EXPENDITURE_ITEM_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, EXPENDITURE_ID
, TASK_ID
, EXPENDITURE_ITEM_DATE
, EXPENDITURE_TYPE
, COST_DISTRIBUTED_FLAG
, REVENUE_DISTRIBUTED_FLAG
, BILLABLE_FLAG
, BILL_HOLD_FLAG
, QUANTITY
, NON_LABOR_RESOURCE
, ORGANIZATION_ID
, JOB_ID
, OVERRIDE_TO_ORGANIZATION_ID
, RAW_COST
, RAW_COST_RATE
, BURDEN_COST
, BURDEN_COST_RATE
, COST_DIST_REJECTION_CODE
, LABOR_COST_MULTIPLIER_NAME
, RAW_REVENUE
, BILL_RATE
, ACCRUED_REVENUE
, ACCRUAL_RATE
, ADJUSTED_REVENUE
, ADJUSTED_RATE
, BILL_AMOUNT
, FORECAST_REVENUE
, BILL_RATE_MULTIPLIER
, REV_DIST_REJECTION_CODE
, EVENT_NUM
, EVENT_TASK_ID
, BILL_JOB_ID
, BILL_JOB_BILLING_TITLE
, BILL_EMPLOYEE_BILLING_TITLE
, ADJUSTED_EXPENDITURE_ITEM_ID
, NET_ZERO_ADJUSTMENT_FLAG
, TRANSFERRED_FROM_EXP_ITEM_ID
, CONVERTED_FLAG
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, COST_IND_COMPILED_SET_ID
, REV_IND_COMPILED_SET_ID
, INV_IND_COMPILED_SET_ID
, COST_BURDEN_DISTRIBUTED_FLAG
, IND_COST_DIST_REJECTION_CODE
, ORIG_TRANSACTION_REFERENCE
, TRANSACTION_SOURCE
, PROJECT_ID
, SOURCE_EXPENDITURE_ITEM_ID
, ORG_ID
, SYSTEM_LINKAGE_FUNCTION
, BURDEN_SUM_DEST_RUN_ID
, RECEIPT_CURRENCY_AMOUNT
, RECEIPT_CURRENCY_CODE
, RECEIPT_EXCHANGE_RATE
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_EXCHANGE_ROUNDING_LIMIT
, 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
, DENORM_ID
, CC_CROSS_CHARGE_CODE
, CC_PRVDR_ORGANIZATION_ID
, CC_RECVR_ORGANIZATION_ID
, CC_REJECTION_CODE
, DENOM_TP_CURRENCY_CODE
, DENOM_TRANSFER_PRICE
, ACCT_TP_RATE_TYPE
, ACCT_TP_RATE_DATE
, ACCT_TP_EXCHANGE_RATE
, ACCT_TRANSFER_PRICE
, PROJACCT_TRANSFER_PRICE
, CC_MARKUP_BASE_CODE
, TP_BASE_AMOUNT
, CC_CROSS_CHARGE_TYPE
, RECVR_ORG_ID
, CC_BL_DISTRIBUTED_CODE
, CC_IC_PROCESSED_CODE
, TP_IND_COMPILED_SET_ID
, TP_BILL_RATE
, TP_BILL_MARKUP_PERCENTAGE
, TP_SCHEDULE_LINE_PERCENTAGE
, TP_RULE_PERCENTAGE
, CC_PRVDR_COST_RECLASS_CODE
, COST_JOB_ID
, TP_JOB_ID
, PROV_PROJ_BILL_JOB_ID
, COST_DIST_WARNING_CODE
, BILL_TRANS_FORECAST_CURR_CODE
, BILL_TRANS_FORECAST_REVENUE
, BILL_TRANS_CURRENCY_CODE
, BILL_TRANS_RAW_REVENUE
, BILL_TRANS_ADJUSTED_REVENUE
, REVPROC_CURRENCY_CODE
, REVPROC_RATE_TYPE
, REVPROC_RATE_DATE
, REVPROC_EXCHANGE_RATE
, INVPROC_CURRENCY_CODE
, INVPROC_RATE_TYPE
, INVPROC_RATE_DATE
, INVPROC_EXCHANGE_RATE
, DISCOUNT_PERCENTAGE
, AMOUNT_CALCULATION_CODE
, BILL_MARKUP_PERCENTAGE
, RATE_SOURCE_ID
, INV_GEN_REJECTION_CODE
, BILL_TRANS_BILL_AMOUNT
, LABOR_MULTIPLIER
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_BILL_AMOUNT
, PROJECT_BILL_AMOUNT
, PROJFUNC_RAW_REVENUE
, PROJECT_RAW_REVENUE
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_EXCHANGE_RATE
, PROJECT_RAW_COST
, PROJECT_BURDENED_COST
, ASSIGNMENT_ID
, WORK_TYPE_ID
, PROJECT_TP_RATE_DATE
, PROJECT_TP_RATE_TYPE
, PROJECT_TP_EXCHANGE_RATE
, PROJECT_TRANSFER_PRICE
, PROJFUNC_TP_RATE_DATE
, PROJFUNC_TP_RATE_TYPE
, PROJFUNC_TP_EXCHANGE_RATE
, PROJFUNC_TRANSFER_PRICE
, TP_AMT_TYPE_CODE
, PROJECT_REV_RATE_TYPE
, PROJECT_REV_RATE_DATE
, PROJECT_REV_EXCHANGE_RATE
, PROJFUNC_REV_RATE_TYPE
, PROJFUNC_REV_RATE_DATE
, PROJFUNC_REV_EXCHANGE_RATE
, PROJFUNC_INV_RATE_TYPE
, PROJFUNC_INV_RATE_DATE
, PROJFUNC_INV_EXCHANGE_RATE
, PROJECT_INV_RATE_TYPE
, PROJECT_INV_RATE_DATE
, PROJECT_INV_EXCHANGE_RATE
, PROJFUNC_FCST_RATE_TYPE
, PROJFUNC_FCST_RATE_DATE
, PROJFUNC_FCST_EXCHANGE_RATE
, PRVDR_ACCRUAL_DATE
, RECVR_ACCRUAL_DATE
, RATE_DISC_REASON_CODE
, CAPITAL_EVENT_ID
, POSTED_DENOM_BURDENED_COST
, POSTED_PROJECT_BURDENED_COST
, POSTED_PROJFUNC_BURDENED_COST
, POSTED_ACCT_BURDENED_COST
, ADJUSTMENT_TYPE
, PO_LINE_ID
, PO_PRICE_TYPE
, WIP_RESOURCE_ID
, INVENTORY_ITEM_ID
, UNIT_OF_MEASURE
FROM PA_EXPENDITURE_ITEMS_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)