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_XLA_EXP_HEADER_V

Object Details

Object Name:	PA_XLA_EXP_HEADER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_XLA_EXP_HEADER_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
EVENT_ID	NUMBER	(15)
EXPENDITURE_ITEM_ID	NUMBER	(15)
GL_DATE	DATE
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)	Yes
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes
EXPENDITURE_ORGANIZATION_ID	NUMBER
EXPENDITURE_OU_ID	NUMBER	(15)
PERSON_ID	NUMBER	(15)
EXPENDITURE_ID	NUMBER	(15)	Yes
EXPENDITURE_CLASS_CODE	VARCHAR2	(2)	Yes
EXPENDITURE_ITEM_DATE	DATE		Yes
ORIG_TRANSACTION_REFERENCE	VARCHAR2	(50)
ORIG_USER_EXP_TXN_REF	VARCHAR2	(60)
ORIG_EXP_TXN_REFERENCE1	VARCHAR2	(60)
ORIG_EXP_TXN_REFERENCE2	VARCHAR2	(60)
ORIG_EXP_TXN_REFERENCE3	VARCHAR2	(60)
INVENTORY_ITEM_ID	NUMBER
WIP_RESOURCE_ID	NUMBER
NON_LABOR_RESOURCE	VARCHAR2	(20)
NL_RES_ORGANIZATION_ID	NUMBER	(15)
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)	Yes
SOURCE_EXPENDITURE_ITEM_ID	NUMBER	(15)
PERSON_TYPE	VARCHAR2	(30)
COST_JOB_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
TRANSACTION_SOURCE	VARCHAR2	(30)
EXCHANGE_RATE_VARIANCE_FLAG	VARCHAR2	(1)
ADJ_EXPENDITURE_ITEM_ID	NUMBER	(15)
CC_PRVDR_ORGANIZATION_ID	NUMBER
OVERRIDE_TO_ORG_ID	NUMBER	(15)
TP_JOB_ID	NUMBER	(15)
TP_AMT_TYPE_CODE	VARCHAR2	(30)
CC_CROSS_CHARGE_TYPE	VARCHAR2	(2)
LABOR_COST_MULTIPLIER_NAME	VARCHAR2	(20)
PEI_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
PEI_ATTRIBUTE1	VARCHAR2	(150)
PEI_ATTRIBUTE2	VARCHAR2	(150)
PEI_ATTRIBUTE3	VARCHAR2	(150)
PEI_ATTRIBUTE4	VARCHAR2	(150)
PEI_ATTRIBUTE5	VARCHAR2	(150)
PEI_ATTRIBUTE6	VARCHAR2	(150)
PEI_ATTRIBUTE7	VARCHAR2	(150)
PEI_ATTRIBUTE8	VARCHAR2	(150)
PEI_ATTRIBUTE9	VARCHAR2	(150)
PEI_ATTRIBUTE10	VARCHAR2	(150)
PE_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
PE_ATTRIBUTE1	VARCHAR2	(150)
PE_ATTRIBUTE2	VARCHAR2	(150)
PE_ATTRIBUTE3	VARCHAR2	(150)
PE_ATTRIBUTE4	VARCHAR2	(150)
PE_ATTRIBUTE5	VARCHAR2	(150)
PE_ATTRIBUTE6	VARCHAR2	(150)
PE_ATTRIBUTE7	VARCHAR2	(150)
PE_ATTRIBUTE8	VARCHAR2	(150)
PE_ATTRIBUTE9	VARCHAR2	(150)
PE_ATTRIBUTE10	VARCHAR2	(150)
PAYROLL_ACCRUAL_FLAG	VARCHAR2	(1)		Payroll accrual flag
EXP_OU_COST_CENTER	VARCHAR2	(0)
EXP_OU_COMPANY	VARCHAR2	(0)

Query Text

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


SELECT EVENT_ID
,      EXPENDITURE_ITEM_ID
,      GL_DATE
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_OU_ID
,      PERSON_ID
,      EXPENDITURE_ID
,      EXPENDITURE_CLASS_CODE
,      EXPENDITURE_ITEM_DATE
,      ORIG_TRANSACTION_REFERENCE
,      ORIG_USER_EXP_TXN_REF
,      ORIG_EXP_TXN_REFERENCE1
,      ORIG_EXP_TXN_REFERENCE2
,      ORIG_EXP_TXN_REFERENCE3
,      INVENTORY_ITEM_ID
,      WIP_RESOURCE_ID
,      NON_LABOR_RESOURCE
,      NL_RES_ORGANIZATION_ID
,      SYSTEM_LINKAGE_FUNCTION
,      SOURCE_EXPENDITURE_ITEM_ID
,      PERSON_TYPE
,      COST_JOB_ID
,      JOB_ID
,      TRANSACTION_SOURCE
,      EXCHANGE_RATE_VARIANCE_FLAG
,      ADJ_EXPENDITURE_ITEM_ID
,      CC_PRVDR_ORGANIZATION_ID
,      OVERRIDE_TO_ORG_ID
,      TP_JOB_ID
,      TP_AMT_TYPE_CODE
,      CC_CROSS_CHARGE_TYPE
,      LABOR_COST_MULTIPLIER_NAME
,      PEI_ATTRIBUTE_CATEGORY
,      PEI_ATTRIBUTE1
,      PEI_ATTRIBUTE2
,      PEI_ATTRIBUTE3
,      PEI_ATTRIBUTE4
,      PEI_ATTRIBUTE5
,      PEI_ATTRIBUTE6
,      PEI_ATTRIBUTE7
,      PEI_ATTRIBUTE8
,      PEI_ATTRIBUTE9
,      PEI_ATTRIBUTE10
,      PE_ATTRIBUTE_CATEGORY
,      PE_ATTRIBUTE1
,      PE_ATTRIBUTE2
,      PE_ATTRIBUTE3
,      PE_ATTRIBUTE4
,      PE_ATTRIBUTE5
,      PE_ATTRIBUTE6
,      PE_ATTRIBUTE7
,      PE_ATTRIBUTE8
,      PE_ATTRIBUTE9
,      PE_ATTRIBUTE10
,      PAYROLL_ACCRUAL_FLAG
,      EXP_OU_COST_CENTER
,      EXP_OU_COMPANY
FROM APPS.PA_XLA_EXP_HEADER_V;