eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: PA.PA_EXPENDITURE_ITEMS_AR#

Object Details

Object Name:	PA_EXPENDITURE_ITEMS_AR#
Object Type:	VIEW
Owner:	PA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PURGE_BATCH_ID	NUMBER	(15)	Yes
PURGE_RELEASE	VARCHAR2	(50)	Yes
PURGE_PROJECT_ID	NUMBER	(15)	Yes
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)
BURDEN_SUM_DEST_RUN_ID	NUMBER	(15)
COST_IND_COMPILED_SET_ID	NUMBER	(15)
REV_IND_COMPILED_SET_ID	NUMBER	(15)
INV_IND_COMPILED_SET_ID	NUMBER	(15)
COST_BURDEN_DISTRIBUTED_FLAG	VARCHAR2	(1)
IND_COST_DIST_REJECTION_CODE	VARCHAR2	(30)
ORIG_TRANSACTION_REFERENCE	VARCHAR2	(50)
TRANSACTION_SOURCE	VARCHAR2	(30)
PROJECT_ID	NUMBER	(15)
SOURCE_EXPENDITURE_ITEM_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)
ADJUSTED_RATE	NUMBER	(22)
BILL_AMOUNT	NUMBER	(22)
FORECAST_REVENUE	NUMBER	(22)
BILL_RATE_MULTIPLIER	NUMBER	(22)
REV_DIST_REJECTION_CODE	VARCHAR2	(30)
EVENT_NUM	NUMBER	(15)
EVENT_TASK_ID	NUMBER	(15)
BILL_JOB_ID	NUMBER	(15)
BILL_JOB_BILLING_TITLE	VARCHAR2	(80)
BILL_EMPLOYEE_BILLING_TITLE	VARCHAR2	(80)
ADJUSTED_EXPENDITURE_ITEM_ID	NUMBER	(15)
NET_ZERO_ADJUSTMENT_FLAG	VARCHAR2	(1)
TRANSFERRED_FROM_EXP_ITEM_ID	NUMBER	(15)
CONVERTED_FLAG	VARCHAR2	(1)
LAST_UPDATE_LOGIN	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
EXPENDITURE_ITEM_ID	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
EXPENDITURE_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
EXPENDITURE_ITEM_DATE	DATE
EXPENDITURE_TYPE	VARCHAR2	(30)
COST_DISTRIBUTED_FLAG	VARCHAR2	(1)
REVENUE_DISTRIBUTED_FLAG	VARCHAR2	(1)
BILLABLE_FLAG	VARCHAR2	(1)
BILL_HOLD_FLAG	VARCHAR2	(1)
QUANTITY	NUMBER	(22)
NON_LABOR_RESOURCE	VARCHAR2	(20)
ORGANIZATION_ID	NUMBER	(15)
OVERRIDE_TO_ORGANIZATION_ID	NUMBER	(15)
RAW_COST	NUMBER	(22)
RAW_COST_RATE	NUMBER	(22)
BURDEN_COST	NUMBER	(22)
BURDEN_COST_RATE	NUMBER	(22)
COST_DIST_REJECTION_CODE	VARCHAR2	(30)
LABOR_COST_MULTIPLIER_NAME	VARCHAR2	(20)
RAW_REVENUE	NUMBER	(22)
BILL_RATE	NUMBER	(22)
ACCRUED_REVENUE	NUMBER	(22)
ACCRUAL_RATE	NUMBER	(22)
DENORM_ID	NUMBER	(15)
ADJUSTED_REVENUE	NUMBER	(22)
RECEIPT_CURRENCY_AMOUNT	NUMBER
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)
RECEIPT_EXCHANGE_RATE	NUMBER
DENOM_CURRENCY_CODE	VARCHAR2	(15)
DENOM_RAW_COST	NUMBER
DENOM_BURDENED_COST	NUMBER
ACCT_CURRENCY_CODE	VARCHAR2	(15)
ACCT_RATE_DATE	DATE
ACCT_RATE_TYPE	VARCHAR2	(30)
ACCT_EXCHANGE_RATE	NUMBER
ACCT_RAW_COST	NUMBER
ACCT_BURDENED_COST	NUMBER
ACCT_EXCHANGE_ROUNDING_LIMIT	NUMBER
PROJECT_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_RATE_DATE	DATE
PROJECT_RATE_TYPE	VARCHAR2	(30)
PROJECT_EXCHANGE_RATE	NUMBER
CC_CROSS_CHARGE_CODE	VARCHAR2	(1)
CC_PRVDR_ORGANIZATION_ID	NUMBER	(15)
CC_RECVR_ORGANIZATION_ID	NUMBER	(15)
CC_REJECTION_CODE	VARCHAR2	(30)
DENOM_TP_CURRENCY_CODE	VARCHAR2	(15)
DENOM_TRANSFER_PRICE	NUMBER
ACCT_TP_RATE_DATE	DATE
ACCT_TP_RATE_TYPE	VARCHAR2	(30)
ACCT_TP_EXCHANGE_RATE	NUMBER
ACCT_TRANSFER_PRICE	NUMBER
PROJACCT_TRANSFER_PRICE	NUMBER
CC_MARKUP_BASE_CODE	VARCHAR2	(1)
TP_BASE_AMOUNT	NUMBER
CC_CROSS_CHARGE_TYPE	VARCHAR2	(2)
RECVR_ORG_ID	NUMBER	(15)
CC_BL_DISTRIBUTED_CODE	VARCHAR2	(1)
CC_IC_PROCESSED_CODE	VARCHAR2	(1)
TP_IND_COMPILED_SET_ID	NUMBER	(15)
TP_BILL_RATE	NUMBER
TP_BILL_MARKUP_PERCENTAGE	NUMBER
TP_SCHEDULE_LINE_PERCENTAGE	NUMBER
TP_RULE_PERCENTAGE	NUMBER
CC_PRVDR_COST_RECLASS_CODE	VARCHAR2	(1)
CRL_ASSET_CREATION_STATUS_CODE	VARCHAR2	(1)
CRL_ASSET_CREATION_REJ_CODE	VARCHAR2	(30)
COST_JOB_ID	NUMBER	(15)
TP_JOB_ID	NUMBER	(15)
PROV_PROJ_BILL_JOB_ID	NUMBER	(15)
COST_DIST_WARNING_CODE	VARCHAR2	(30)
PROJECT_TP_RATE_DATE	DATE
PROJECT_TP_RATE_TYPE	VARCHAR2	(30)
PROJECT_TP_EXCHANGE_RATE	NUMBER
PROJFUNC_TP_RATE_DATE	DATE
PROJFUNC_TP_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_TP_EXCHANGE_RATE	NUMBER
PROJFUNC_TRANSFER_PRICE	NUMBER
BILL_TRANS_FORECAST_CURR_CODE	VARCHAR2	(15)
BILL_TRANS_FORECAST_REVENUE	NUMBER
PROJFUNC_REV_RATE_DATE	DATE
PROJFUNC_REV_EXCHANGE_RATE	NUMBER
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_COST_RATE_DATE	VARCHAR2	(240)
PROJFUNC_COST_EXCHANGE_RATE	NUMBER
PROJECT_RAW_COST	NUMBER
PROJECT_BURDENED_COST	NUMBER
ASSIGNMENT_ID	NUMBER	(15)
WORK_TYPE_ID	NUMBER	(15)
PROJFUNC_RAW_REVENUE	NUMBER
PROJECT_BILL_AMOUNT	NUMBER
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_RAW_REVENUE	NUMBER
PROJECT_TRANSFER_PRICE	NUMBER
TP_AMT_TYPE_CODE	VARCHAR2	(30)
BILL_TRANS_CURRENCY_CODE	VARCHAR2	(15)
BILL_TRANS_RAW_REVENUE	NUMBER
BILL_TRANS_BILL_AMOUNT	NUMBER
BILL_TRANS_ADJUSTED_REVENUE	NUMBER
REVPROC_CURRENCY_CODE	VARCHAR2	(15)
REVPROC_RATE_TYPE	VARCHAR2	(30)
REVPROC_RATE_DATE	VARCHAR2	(240)
REVPROC_EXCHANGE_RATE	NUMBER
INVPROC_CURRENCY_CODE	VARCHAR2	(15)
INVPROC_RATE_TYPE	VARCHAR2	(30)
INVPROC_RATE_DATE	DATE
DISCOUNT_PERCENTAGE	NUMBER
LABOR_MULTIPLIER	NUMBER
AMOUNT_CALCULATION_CODE	VARCHAR2	(15)
BILL_MARKUP_PERCENTAGE	NUMBER
RATE_SOURCE_ID	NUMBER	(15)
INVPROC_EXCHANGE_RATE	NUMBER
INV_GEN_REJECTION_CODE	VARCHAR2	(30)
PROJFUNC_BILL_AMOUNT	NUMBER
PROJECT_REV_RATE_TYPE	VARCHAR2	(30)
PROJECT_REV_RATE_DATE	VARCHAR2	(240)
PROJECT_REV_EXCHANGE_RATE	NUMBER
PROJFUNC_REV_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_INV_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_INV_RATE_DATE	DATE
PROJFUNC_INV_EXCHANGE_RATE	NUMBER
PROJECT_INV_RATE_TYPE	VARCHAR2	(30)
PROJECT_INV_RATE_DATE	VARCHAR2	(240)
PROJECT_INV_EXCHANGE_RATE	NUMBER
PROJFUNC_FCST_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_FCST_RATE_DATE	VARCHAR2	(240)
PROJFUNC_FCST_EXCHANGE_RATE	NUMBER
PRVDR_ACCRUAL_DATE	DATE
RECVR_ACCRUAL_DATE	VARCHAR2	(240)
RATE_DISC_REASON_CODE	VARCHAR2	(30)
POSTED_DENOM_BURDENED_COST	NUMBER
POSTED_PROJECT_BURDENED_COST	NUMBER
POSTED_PROJFUNC_BURDENED_COST	NUMBER
POSTED_ACCT_BURDENED_COST	NUMBER
ADJUSTMENT_TYPE	VARCHAR2	(150)
CAPITAL_EVENT_ID	NUMBER	(15)
PO_LINE_ID	NUMBER
PO_PRICE_TYPE	VARCHAR2	(30)
INVENTORY_ITEM_ID	NUMBER
WIP_RESOURCE_ID	NUMBER
UNIT_OF_MEASURE	VARCHAR2	(30)
DOCUMENT_HEADER_ID	NUMBER	(15)
DOCUMENT_DISTRIBUTION_ID	NUMBER	(15)
DOCUMENT_LINE_NUMBER	NUMBER	(15)
DOCUMENT_PAYMENT_ID	NUMBER	(15)
VENDOR_ID	NUMBER	(15)
DOCUMENT_TYPE	VARCHAR2	(30)
DOCUMENT_DISTRIBUTION_TYPE	VARCHAR2	(30)
LOCATION_ID	NUMBER	(15)
PAY_ELEMENT_TYPE_ID	NUMBER	(15)
CBS_ELEMENT_ID	NUMBER	(15)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PURGE_BATCH_ID
,      PURGE_RELEASE
,      PURGE_PROJECT_ID
,      SYSTEM_LINKAGE_FUNCTION
,      BURDEN_SUM_DEST_RUN_ID
,      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
,      JOB_ID
,      ORG_ID
,      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
,      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
,      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
,      DENORM_ID
,      ADJUSTED_REVENUE
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_EXCHANGE_RATE
,      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
,      ACCT_EXCHANGE_ROUNDING_LIMIT
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      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_DATE
,      ACCT_TP_RATE_TYPE
,      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
,      CRL_ASSET_CREATION_STATUS_CODE
,      CRL_ASSET_CREATION_REJ_CODE
,      COST_JOB_ID
,      TP_JOB_ID
,      PROV_PROJ_BILL_JOB_ID
,      COST_DIST_WARNING_CODE
,      PROJECT_TP_RATE_DATE
,      PROJECT_TP_RATE_TYPE
,      PROJECT_TP_EXCHANGE_RATE
,      PROJFUNC_TP_RATE_DATE
,      PROJFUNC_TP_RATE_TYPE
,      PROJFUNC_TP_EXCHANGE_RATE
,      PROJFUNC_TRANSFER_PRICE
,      BILL_TRANS_FORECAST_CURR_CODE
,      BILL_TRANS_FORECAST_REVENUE
,      PROJFUNC_REV_RATE_DATE
,      PROJFUNC_REV_EXCHANGE_RATE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_RATE_DATE
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJECT_RAW_COST
,      PROJECT_BURDENED_COST
,      ASSIGNMENT_ID
,      WORK_TYPE_ID
,      PROJFUNC_RAW_REVENUE
,      PROJECT_BILL_AMOUNT
,      PROJFUNC_CURRENCY_CODE
,      PROJECT_RAW_REVENUE
,      PROJECT_TRANSFER_PRICE
,      TP_AMT_TYPE_CODE
,      BILL_TRANS_CURRENCY_CODE
,      BILL_TRANS_RAW_REVENUE
,      BILL_TRANS_BILL_AMOUNT
,      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
,      DISCOUNT_PERCENTAGE
,      LABOR_MULTIPLIER
,      AMOUNT_CALCULATION_CODE
,      BILL_MARKUP_PERCENTAGE
,      RATE_SOURCE_ID
,      INVPROC_EXCHANGE_RATE
,      INV_GEN_REJECTION_CODE
,      PROJFUNC_BILL_AMOUNT
,      PROJECT_REV_RATE_TYPE
,      PROJECT_REV_RATE_DATE
,      PROJECT_REV_EXCHANGE_RATE
,      PROJFUNC_REV_RATE_TYPE
,      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
,      POSTED_DENOM_BURDENED_COST
,      POSTED_PROJECT_BURDENED_COST
,      POSTED_PROJFUNC_BURDENED_COST
,      POSTED_ACCT_BURDENED_COST
,      ADJUSTMENT_TYPE
,      CAPITAL_EVENT_ID
,      PO_LINE_ID
,      PO_PRICE_TYPE
,      INVENTORY_ITEM_ID
,      WIP_RESOURCE_ID
,      UNIT_OF_MEASURE
,      DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      DOCUMENT_LINE_NUMBER
,      DOCUMENT_PAYMENT_ID
,      VENDOR_ID
,      DOCUMENT_TYPE
,      DOCUMENT_DISTRIBUTION_TYPE
,      LOCATION_ID
,      PAY_ELEMENT_TYPE_ID
,      CBS_ELEMENT_ID
FROM PA.PA_EXPENDITURE_ITEMS_AR#;

Dependencies

[top of page]

PA.PA_EXPENDITURE_ITEMS_AR# references the following:

PA: PA_EXPENDITURE_ITEMS_AR

PA.PA_EXPENDITURE_ITEMS_AR# is referenced by following:

APPS: PA_EXPENDITURE_ITEMS_AR