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]

TABLE: PA.PA_EXPENDITURES_AR

Object Details

Object Name:	PA_EXPENDITURES_AR
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_EXPENDITURES_AR
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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_EXPENDITURES_AR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PURGE_PROJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PURGE_BATCH_ID	NUMBER	(15)	Yes	Purge batch Id
PURGE_RELEASE	VARCHAR2	(50)	Yes	Purge Release Version
PURGE_PROJECT_ID	NUMBER	(15)	Yes	Purge Project Id
REQUEST_ID	NUMBER	(15)		Concurrent program Who column
PROGRAM_ID	NUMBER	(15)		Concurrent program Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent program Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent program 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
PTE_REFERENCE	NUMBER	(15)		The expenditure id of the PA_EXPENDITURES table in the local database for Oracle Personal Time and Expense
ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations
EXPENDITURE_ID	NUMBER	(15)		The system-generated number that uniquely identifies the expenditure
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
EXPENDITURE_STATUS_CODE	VARCHAR2	(30)		The status of the expenditure as it is entered and approved
EXPENDITURE_ENDING_DATE	DATE			The last day of the expenditure week period. All expenditure items for the expenditure must be on or before this expenditure ending date. All timecard items must be within this expenditure ending date period
EXPENDITURE_CLASS_CODE	VARCHAR2	(2)		The classification of the expenditure, indicating the type of items grouped into it
INCURRED_BY_PERSON_ID	NUMBER	(15)		The identifier of the employee who incurred the charges. This column is always populated for labor and expense report charges and is not populated for supplier invoices. For usages, specifying employees who incurred the charges is optional
INCURRED_BY_ORGANIZATION_ID	NUMBER	(15)		The identifier of the organization that incurred the charges. Column is populated for all charges except supplier invoices, where the organization is held at the expenditure item level,as each inv distribution may have different org
EXPENDITURE_GROUP	VARCHAR2	(240)		The expenditure group to which expenditure belongs. This is only applicable for pre-approved expenditures. This column is blank for online expenditures
CONTROL_TOTAL_AMOUNT	NUMBER	(22)		The user-entered control total of the expenditure items for the expenditure
ENTERED_BY_PERSON_ID	NUMBER	(15)		The identifier of the person who entered the expenditure. This value is not populated for supplier invoice expenditures
DESCRIPTION	VARCHAR2	(250)		The comment of the online expenditures
INITIAL_SUBMISSION_DATE	DATE			The date on which the online expenditure was initially submitted
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
DENOM_CURRENCY_CODE	VARCHAR2	(15)		Transaction Currency of the transaction
ACCT_CURRENCY_CODE	VARCHAR2	(15)		Functional Currency of the transaction
ACCT_RATE_DATE	DATE			Functional Currency conversion rate date
ACCT_RATE_TYPE	VARCHAR2	(30)		Functional Currency conversion rate type
ACCT_EXCHANGE_RATE	NUMBER			Functional Currency conversion exchange rate
ORIG_EXP_TXN_REFERENCE1	VARCHAR2	(60)		Expenditure Identifier in external system(system reference) For Supplier invoices created in Oracle Payables, this holds the value of AP_INVOICESINVOICE_ID
ORIG_EXP_TXN_REFERENCE2	VARCHAR2	(60)		Additional colum provided to group imported transactions into expenditures
ORIG_EXP_TXN_REFERENCE3	VARCHAR2	(60)		Additional colum provided to group imported transactions into expenditures
ORIG_USER_EXP_TXN_REFERENCE	VARCHAR2	(60)		User reference for the expenditure that may be populated for items imported into Projects via Transaction Import For Supplier Invoices, this holds the value of AP_INVOICESINVOICE_NUM For timecards created via Oracle Self Service Time, thi
VENDOR_ID	NUMBER	(15)		Identifier of the supplier
OVERRIDING_APPROVER_PERSON_ID	NUMBER	(15)		For Oracle Self Service Time use only The Overriding Approver to whom this timecard was sent for approval
WF_STATUS_CODE	VARCHAR2	(30)		This column stores the workflow status code for Self Service Time timecards
TRANSFER_STATUS_CODE	VARCHAR2	(1)		The status of the timecard as the timecard is transferred from Self Service Time to Oracle Projects
USER_BATCH_NAME	VARCHAR2	(50)		Batch name for timecards entered through Self Service Time, used to group timecards into batches through Transaction Import
PERSON_TYPE	VARCHAR2	(30)		Type of person who incurred the expenditure

Query Text

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


SELECT PURGE_BATCH_ID
,      PURGE_RELEASE
,      PURGE_PROJECT_ID
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      PTE_REFERENCE
,      ORG_ID
,      EXPENDITURE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      EXPENDITURE_STATUS_CODE
,      EXPENDITURE_ENDING_DATE
,      EXPENDITURE_CLASS_CODE
,      INCURRED_BY_PERSON_ID
,      INCURRED_BY_ORGANIZATION_ID
,      EXPENDITURE_GROUP
,      CONTROL_TOTAL_AMOUNT
,      ENTERED_BY_PERSON_ID
,      DESCRIPTION
,      INITIAL_SUBMISSION_DATE
,      LAST_UPDATE_LOGIN
,      DENOM_CURRENCY_CODE
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      ORIG_EXP_TXN_REFERENCE1
,      ORIG_EXP_TXN_REFERENCE2
,      ORIG_EXP_TXN_REFERENCE3
,      ORIG_USER_EXP_TXN_REFERENCE
,      VENDOR_ID
,      OVERRIDING_APPROVER_PERSON_ID
,      WF_STATUS_CODE
,      TRANSFER_STATUS_CODE
,      USER_BATCH_NAME
,      PERSON_TYPE
FROM PA.PA_EXPENDITURES_AR;

Dependencies

[top of page]

PA.PA_EXPENDITURES_AR does not reference any database object

PA.PA_EXPENDITURES_AR is referenced by following:

APPS: PA_EXPENDITURES_AR