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: APPS.PA_EXPENDITURE_ITEMS_V

Object Details

Object Name:	PA_EXPENDITURE_ITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_EXPENDITURE_ITEMS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes
EXPENDITURE_ID	NUMBER	(15)	Yes
PROJECT_ID	NUMBER	(15)	Yes
PROJECT_NUMBER	VARCHAR2	(25)	Yes
PROJECT_NAME	VARCHAR2	(30)	Yes
TASK_ID	NUMBER	(15)	Yes
TASK_NUMBER	VARCHAR2	(25)	Yes
TASK_NAME	VARCHAR2	(20)	Yes
TASK_DESCRIPTION	VARCHAR2	(250)
NLR_ORGANIZATION_NAME	VARCHAR2	(240)
EXPENDITURE_GROUP	VARCHAR2	(240)	Yes
EXPENDITURE_STATUS_CODE	VARCHAR2	(30)	Yes
INCURRED_BY_PERSON_ID	NUMBER	(15)
UNIT_OF_MEASURE_M	VARCHAR2	(80)	Yes
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)	Yes
EXPENDITURE_ITEM_DATE	DATE		Yes
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes
EXPENDITURE_COMMENT	VARCHAR2	(240)
COST_DISTRIBUTED_FLAG	VARCHAR2	(1)	Yes
REVENUE_DISTRIBUTED_FLAG	VARCHAR2	(1)	Yes
BILLABLE_FLAG	VARCHAR2	(1)	Yes
BILL_HOLD_FLAG	VARCHAR2	(1)	Yes
QUANTITY	NUMBER
NON_LABOR_RESOURCE	VARCHAR2	(20)
ORGANIZATION_ID	NUMBER	(15)
OVERRIDE_TO_ORGANIZATION_ID	NUMBER	(15)
RAW_COST	NUMBER
RAW_COST_RATE	NUMBER
BURDEN_COST	NUMBER
BURDEN_COST_RATE	NUMBER
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)
ADJUSTED_REVENUE	NUMBER	(22)
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)		Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
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	(30)
TRANSACTION_SOURCE	VARCHAR2	(30)
SOURCE_EXPENDITURE_ITEM_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
USER_TRANSACTION_SOURCE	VARCHAR2	(80)
BURDEN_SUM_DEST_RUN_ID	NUMBER	(15)		Burden Summarization Destination Run Id
RECEIPT_CURRENCY_AMOUNT	NUMBER			Receipt currency amount of the transaction
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)		Receipt currency code of the transaction
RECEIPT_EXCHANGE_RATE	NUMBER			Receipt exchange rate for the transaction
DENOM_CURRENCY_CODE	VARCHAR2	(15)		Denomination currency code of the transaction
DENOM_RAW_COST	NUMBER			Raw cost in denomination currency
DENOM_BURDENED_COST	NUMBER			Burdened cost in Denomination currency
ACCT_EXCHANGE_ROUNDING_LIMIT	NUMBER			Rounding limit for imported transactions
ACCT_CURRENCY_CODE	VARCHAR2	(15)		Account currency code of the transaction
ACCT_RATE_DATE	DATE			Accounting rate date for the transaction
ACCT_RATE_TYPE	VARCHAR2	(30)		Accounting rate type for the transaction
ACCT_EXCHANGE_RATE	NUMBER			Accounting exchange rate for the transaction
ACCT_RAW_COST	NUMBER			Raw cost in accounting currency
ACCT_BURDENED_COST	NUMBER			Burdened cost in Accounting currency
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		Project currency code of the transaction
PROJECT_RATE_DATE	DATE			Project rate date for the transaction
PROJECT_RATE_TYPE	VARCHAR2	(30)		Project rate type for the transaction
PROJECT_EXCHANGE_RATE	NUMBER			Project exchange rate for the transaction
COST_RATE_FLAG	VARCHAR2	(1)	Yes	Cost Rate Flag
INCURRED_BY_ORGANIZATION_ID	NUMBER	(15)
ALLOW_REVERSAL_FLAG	VARCHAR2	(1)		Expenditure Group is allowed to be reversed or not
RECVR_ORG_ID	NUMBER	(15)
COST_JOB_ID	NUMBER	(15)		Costing Job Id
PROV_PROJ_BILL_JOB_ID	NUMBER	(15)		Provider Project Job Id
TP_JOB_ID	NUMBER	(15)		Borrow Lent Job Id
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)
PROJFUNC_BILL_AMOUNT	NUMBER
PROJECT_BILL_AMOUNT	NUMBER
PROJFUNC_RAW_REVENUE	NUMBER
PROJECT_RAW_REVENUE	NUMBER
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_COST_RATE_DATE	DATE
PROJFUNC_COST_EXCHANGE_RATE	NUMBER
PROJECT_RAW_COST	NUMBER
PROJECT_BURDENED_COST	NUMBER
ASSIGNMENT_ID	NUMBER	(15)
WORK_TYPE_ID	NUMBER	(15)
TP_AMT_TYPE_CODE	VARCHAR2	(30)
WORK_TYPE_NAME	VARCHAR2	(4000)
ASSIGNMENT_NAME	VARCHAR2	(4000)
PRVDR_ACCRUAL_DATE	DATE			The accrual date for the provider side of the expenditure item
RECVR_ACCRUAL_DATE	DATE			The accrual date for the receiver side of the expenditure item
CAPITAL_EVENT_ID	NUMBER	(15)		Identifier of the Capital Event
PO_LINE_ID	NUMBER
PO_PRICE_TYPE	VARCHAR2	(30)
PO_NUMBER	VARCHAR2	(20)
PO_LINE_NUMBER	NUMBER
PO_PRICE_TYPE_M	VARCHAR2	(80)
WIP_RESOURCE_ID	NUMBER
INVENTORY_ITEM_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)
DOCUMENT_TYPE	VARCHAR2	(30)
DOCUMENT_DISTRIBUTION_TYPE	VARCHAR2	(30)
VENDOR_ID	NUMBER	(15)

Query Text

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


SELECT ROW_ID
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_ID
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      TASK_DESCRIPTION
,      NLR_ORGANIZATION_NAME
,      EXPENDITURE_GROUP
,      EXPENDITURE_STATUS_CODE
,      INCURRED_BY_PERSON_ID
,      UNIT_OF_MEASURE_M
,      SYSTEM_LINKAGE_FUNCTION
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_TYPE
,      EXPENDITURE_COMMENT
,      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
,      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
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      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
,      SOURCE_EXPENDITURE_ITEM_ID
,      JOB_ID
,      USER_TRANSACTION_SOURCE
,      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
,      COST_RATE_FLAG
,      INCURRED_BY_ORGANIZATION_ID
,      ALLOW_REVERSAL_FLAG
,      RECVR_ORG_ID
,      COST_JOB_ID
,      PROV_PROJ_BILL_JOB_ID
,      TP_JOB_ID
,      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
,      TP_AMT_TYPE_CODE
,      WORK_TYPE_NAME
,      ASSIGNMENT_NAME
,      PRVDR_ACCRUAL_DATE
,      RECVR_ACCRUAL_DATE
,      CAPITAL_EVENT_ID
,      PO_LINE_ID
,      PO_PRICE_TYPE
,      PO_NUMBER
,      PO_LINE_NUMBER
,      PO_PRICE_TYPE_M
,      WIP_RESOURCE_ID
,      INVENTORY_ITEM_ID
,      UNIT_OF_MEASURE
,      DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      DOCUMENT_LINE_NUMBER
,      DOCUMENT_PAYMENT_ID
,      DOCUMENT_TYPE
,      DOCUMENT_DISTRIBUTION_TYPE
,      VENDOR_ID
FROM APPS.PA_EXPENDITURE_ITEMS_V;

Dependencies

[top of page]

APPS.PA_EXPENDITURE_ITEMS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HR_ALL_ORGANIZATION_UNITS_TL; HR_GENERAL - show dependent code; HR_ORG_UNITS_NO_JOIN; HR_SECURITY - show dependent code; PA_EXPENDITURES; PA_EXPENDITURE_COMMENTS; PA_EXPENDITURE_ITEMS; PA_EXPENDITURE_TYPES; PA_LOOKUPS; PA_PROJECTS_ALL; PA_TASKS; PA_TRANSACTION_SOURCES; PA_UTILS4 - show dependent code; PO_HEADERS_ALL; PO_LINES_ALL

APPS.PA_EXPENDITURE_ITEMS_V is not referenced by any database object