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_ALL

Object Details

Object Name:	PA_EXPENDITURES_ALL
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_EXPENDITURES_ALL
Subobject Name:
Status:	VALID

PA_EXPENDITURES_ALL stores groupings of expenditure
items incurred by an employee or an organization
for a specific expenditure period. An expenditure
also exists for each suppier invoice transferred to
Oracle Projects from Oracle Payables.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_EXPENDITURES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ID
PA_EXPENDITURES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCURRED_BY_PERSON_ID EXPENDITURE_ENDING_DATE
PA_EXPENDITURES_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID ORIG_EXP_TXN_REFERENCE1
PA_EXPENDITURES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCURRED_BY_ORGANIZATION_ID
PA_EXPENDITURES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENDITURE_GROUP
PA_EXPENDITURES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENDITURE_STATUS_CODE
PA_EXPENDITURES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTERED_BY_PERSON_ID
PA_EXPENDITURES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
PA_EXPENDITURES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE1
PA_EXPENDITURES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSFER_STATUS_CODE
PA_EXPENDITURES_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENDITURE_GROUP INCURRED_BY_ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EXPENDITURE_ID	NUMBER	(15)	Yes	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)	Yes	The status of the expenditure as it is entered and approved
EXPENDITURE_ENDING_DATE	DATE		Yes	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)	Yes	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)	Yes	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
REQUEST_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			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
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)	Yes	Operating unit identifier for multi-organization installations
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 reference holds the value of AP_INVOICES.INVOICE_NUM. Please note that this reference may become outdated if the invoice number is changed after the import.
VENDOR_ID	NUMBER			Identifier of the supplier
OVERRIDING_APPROVER_PERSON_ID	NUMBER			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 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
,      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
,      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_ALL;

Dependencies

[top of page]

PA.PA_EXPENDITURES_ALL does not reference any database object

PA.PA_EXPENDITURES_ALL is referenced by following:

PA: PA_EXPENDITURES_ALL#