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_EI_DENORM#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
EXPENDITURE_ID	NUMBER	(15)	Yes
DENORM_ID	NUMBER	(15)	Yes
PERSON_ID	NUMBER	(15)	Yes
PROJECT_ID	NUMBER	(15)	Yes
TASK_ID	NUMBER	(15)	Yes
BILLABLE_FLAG	VARCHAR2	(1)	Yes
EXPENDITURE_TYPE	VARCHAR2	(30)
DEFAULT_SYS_LINK_FUNC	VARCHAR2	(3)
UNIT_OF_MEASURE_CODE	VARCHAR2	(30)
UNIT_OF_MEASURE	VARCHAR2	(80)
EXPENDITURE_ITEM_ID_1	NUMBER	(15)
EXPENDITURE_ITEM_DATE_1	DATE
QUANTITY_1	NUMBER	(22)
SYSTEM_LINKAGE_FUNCTION_1	VARCHAR2	(30)
NON_LABOR_RESOURCE_1	VARCHAR2	(20)
ORGANIZATION_ID_1	NUMBER	(15)
OVERRIDE_TO_ORGANIZATION_ID_1	NUMBER	(15)
RAW_COST_1	NUMBER	(22)
RAW_COST_RATE_1	NUMBER	(22)
ATTRIBUTE_CATEGORY_1	VARCHAR2	(30)
ATTRIBUTE1_1	VARCHAR2	(150)
ATTRIBUTE1_2	VARCHAR2	(150)
ATTRIBUTE1_3	VARCHAR2	(150)
ATTRIBUTE1_4	VARCHAR2	(150)
ATTRIBUTE1_5	VARCHAR2	(150)
ATTRIBUTE1_6	VARCHAR2	(150)
ATTRIBUTE1_7	VARCHAR2	(150)
ATTRIBUTE1_8	VARCHAR2	(150)
ATTRIBUTE1_9	VARCHAR2	(150)
ATTRIBUTE1_10	VARCHAR2	(150)
ORIG_TRANSACTION_REFERENCE_1	VARCHAR2	(50)
ADJUSTED_EXPENDITURE_ITEM_ID_1	NUMBER	(15)
NET_ZERO_ADJUSTMENT_FLAG_1	VARCHAR2	(1)
EXPENDITURE_COMMENT_1	VARCHAR2	(240)
EXPENDITURE_ITEM_ID_2	NUMBER	(15)
EXPENDITURE_ITEM_DATE_2	DATE
QUANTITY_2	NUMBER	(22)
SYSTEM_LINKAGE_FUNCTION_2	VARCHAR2	(30)
NON_LABOR_RESOURCE_2	VARCHAR2	(20)
ORGANIZATION_ID_2	NUMBER	(15)
OVERRIDE_TO_ORGANIZATION_ID_2	NUMBER	(15)
RAW_COST_2	NUMBER	(22)
RAW_COST_RATE_2	NUMBER	(22)
ATTRIBUTE_CATEGORY_2	VARCHAR2	(30)
ATTRIBUTE2_1	VARCHAR2	(150)
ATTRIBUTE2_2	VARCHAR2	(150)
ATTRIBUTE2_3	VARCHAR2	(150)
ATTRIBUTE2_4	VARCHAR2	(150)
ATTRIBUTE2_5	VARCHAR2	(150)
ATTRIBUTE2_6	VARCHAR2	(150)
ATTRIBUTE2_7	VARCHAR2	(150)
ATTRIBUTE2_8	VARCHAR2	(150)
ATTRIBUTE2_9	VARCHAR2	(150)
ATTRIBUTE2_10	VARCHAR2	(150)
ORIG_TRANSACTION_REFERENCE_2	VARCHAR2	(50)
ADJUSTED_EXPENDITURE_ITEM_ID_2	NUMBER	(15)
NET_ZERO_ADJUSTMENT_FLAG_2	VARCHAR2	(1)
EXPENDITURE_COMMENT_2	VARCHAR2	(240)
EXPENDITURE_ITEM_ID_3	NUMBER	(15)
EXPENDITURE_ITEM_DATE_3	DATE
QUANTITY_3	NUMBER	(22)
SYSTEM_LINKAGE_FUNCTION_3	VARCHAR2	(30)
NON_LABOR_RESOURCE_3	VARCHAR2	(20)
ORGANIZATION_ID_3	NUMBER	(15)
OVERRIDE_TO_ORGANIZATION_ID_3	NUMBER	(15)
RAW_COST_3	NUMBER	(22)
RAW_COST_RATE_3	NUMBER	(22)
ATTRIBUTE_CATEGORY_3	VARCHAR2	(30)
ATTRIBUTE3_1	VARCHAR2	(150)
ATTRIBUTE3_2	VARCHAR2	(150)
ATTRIBUTE3_3	VARCHAR2	(150)
ATTRIBUTE3_4	VARCHAR2	(150)
ATTRIBUTE3_5	VARCHAR2	(150)
ATTRIBUTE3_6	VARCHAR2	(150)
ATTRIBUTE3_7	VARCHAR2	(150)
ATTRIBUTE3_8	VARCHAR2	(150)
ATTRIBUTE3_9	VARCHAR2	(150)
ATTRIBUTE3_10	VARCHAR2	(150)
ORIG_TRANSACTION_REFERENCE_3	VARCHAR2	(50)
ADJUSTED_EXPENDITURE_ITEM_ID_3	NUMBER	(15)
NET_ZERO_ADJUSTMENT_FLAG_3	VARCHAR2	(1)
EXPENDITURE_COMMENT_3	VARCHAR2	(240)
EXPENDITURE_ITEM_ID_4	NUMBER	(15)
EXPENDITURE_ITEM_DATE_4	DATE
QUANTITY_4	NUMBER	(22)
SYSTEM_LINKAGE_FUNCTION_4	VARCHAR2	(30)
NON_LABOR_RESOURCE_4	VARCHAR2	(20)
ORGANIZATION_ID_4	NUMBER	(15)
OVERRIDE_TO_ORGANIZATION_ID_4	NUMBER	(15)
RAW_COST_4	NUMBER	(22)
RAW_COST_RATE_4	NUMBER	(22)
ATTRIBUTE_CATEGORY_4	VARCHAR2	(30)
ATTRIBUTE4_1	VARCHAR2	(150)
ATTRIBUTE4_2	VARCHAR2	(150)
ATTRIBUTE4_3	VARCHAR2	(150)
ATTRIBUTE4_4	VARCHAR2	(150)
ATTRIBUTE4_5	VARCHAR2	(150)
ATTRIBUTE4_6	VARCHAR2	(150)
ATTRIBUTE4_7	VARCHAR2	(150)
ATTRIBUTE4_8	VARCHAR2	(150)
ATTRIBUTE4_9	VARCHAR2	(150)
ATTRIBUTE4_10	VARCHAR2	(150)
ORIG_TRANSACTION_REFERENCE_4	VARCHAR2	(50)
ADJUSTED_EXPENDITURE_ITEM_ID_4	NUMBER	(15)
NET_ZERO_ADJUSTMENT_FLAG_4	VARCHAR2	(1)
EXPENDITURE_COMMENT_4	VARCHAR2	(240)
EXPENDITURE_ITEM_ID_5	NUMBER	(15)
EXPENDITURE_ITEM_DATE_5	DATE
QUANTITY_5	NUMBER	(22)
SYSTEM_LINKAGE_FUNCTION_5	VARCHAR2	(30)
NON_LABOR_RESOURCE_5	VARCHAR2	(20)
ORGANIZATION_ID_5	NUMBER	(15)
OVERRIDE_TO_ORGANIZATION_ID_5	NUMBER	(15)
RAW_COST_5	NUMBER	(22)
RAW_COST_RATE_5	NUMBER	(22)
ATTRIBUTE_CATEGORY_5	VARCHAR2	(30)
ATTRIBUTE5_1	VARCHAR2	(150)
ATTRIBUTE5_2	VARCHAR2	(150)
ATTRIBUTE5_3	VARCHAR2	(150)
ATTRIBUTE5_4	VARCHAR2	(150)
ATTRIBUTE5_5	VARCHAR2	(150)
ATTRIBUTE5_6	VARCHAR2	(150)
ATTRIBUTE5_7	VARCHAR2	(150)
ATTRIBUTE5_8	VARCHAR2	(150)
ATTRIBUTE5_9	VARCHAR2	(150)
ATTRIBUTE5_10	VARCHAR2	(150)
ORIG_TRANSACTION_REFERENCE_5	VARCHAR2	(50)
ADJUSTED_EXPENDITURE_ITEM_ID_5	NUMBER	(15)
NET_ZERO_ADJUSTMENT_FLAG_5	VARCHAR2	(1)
EXPENDITURE_COMMENT_5	VARCHAR2	(240)
EXPENDITURE_ITEM_ID_6	NUMBER	(15)
EXPENDITURE_ITEM_DATE_6	DATE
QUANTITY_6	NUMBER	(22)
SYSTEM_LINKAGE_FUNCTION_6	VARCHAR2	(30)
NON_LABOR_RESOURCE_6	VARCHAR2	(20)
ORGANIZATION_ID_6	NUMBER	(15)
OVERRIDE_TO_ORGANIZATION_ID_6	NUMBER	(15)
RAW_COST_6	NUMBER	(22)
RAW_COST_RATE_6	NUMBER	(22)
ATTRIBUTE_CATEGORY_6	VARCHAR2	(30)
ATTRIBUTE6_1	VARCHAR2	(150)
ATTRIBUTE6_2	VARCHAR2	(150)
ATTRIBUTE6_3	VARCHAR2	(150)
ATTRIBUTE6_4	VARCHAR2	(150)
ATTRIBUTE6_5	VARCHAR2	(150)
ATTRIBUTE6_6	VARCHAR2	(150)
ATTRIBUTE6_7	VARCHAR2	(150)
ATTRIBUTE6_8	VARCHAR2	(150)
ATTRIBUTE6_9	VARCHAR2	(150)
ATTRIBUTE6_10	VARCHAR2	(150)
ORIG_TRANSACTION_REFERENCE_6	VARCHAR2	(50)
ADJUSTED_EXPENDITURE_ITEM_ID_6	NUMBER	(15)
NET_ZERO_ADJUSTMENT_FLAG_6	VARCHAR2	(1)
EXPENDITURE_COMMENT_6	VARCHAR2	(240)
EXPENDITURE_ITEM_ID_7	NUMBER	(15)
EXPENDITURE_ITEM_DATE_7	DATE
QUANTITY_7	NUMBER	(22)
SYSTEM_LINKAGE_FUNCTION_7	VARCHAR2	(30)
NON_LABOR_RESOURCE_7	VARCHAR2	(20)
ORGANIZATION_ID_7	NUMBER	(15)
OVERRIDE_TO_ORGANIZATION_ID_7	NUMBER	(15)
RAW_COST_7	NUMBER	(22)
RAW_COST_RATE_7	NUMBER	(22)
ATTRIBUTE_CATEGORY_7	VARCHAR2	(30)
ATTRIBUTE7_1	VARCHAR2	(150)
ATTRIBUTE7_2	VARCHAR2	(150)
ATTRIBUTE7_3	VARCHAR2	(150)
ATTRIBUTE7_4	VARCHAR2	(150)
ATTRIBUTE7_5	VARCHAR2	(150)
ATTRIBUTE7_6	VARCHAR2	(150)
ATTRIBUTE7_7	VARCHAR2	(150)
ATTRIBUTE7_8	VARCHAR2	(150)
ATTRIBUTE7_9	VARCHAR2	(150)
ATTRIBUTE7_10	VARCHAR2	(150)
ORIG_TRANSACTION_REFERENCE_7	VARCHAR2	(50)
ADJUSTED_EXPENDITURE_ITEM_ID_7	NUMBER	(15)
NET_ZERO_ADJUSTMENT_FLAG_7	VARCHAR2	(1)
EXPENDITURE_COMMENT_7	VARCHAR2	(240)
DENORM_TOTAL_QTY	NUMBER	(22)
DENORM_TOTAL_AMOUNT	NUMBER	(22)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
JOB_ID_1	NUMBER	(15)
JOB_ID_2	NUMBER	(15)
JOB_ID_3	NUMBER	(15)
JOB_ID_4	NUMBER	(15)
JOB_ID_5	NUMBER	(15)
JOB_ID_6	NUMBER	(15)
JOB_ID_7	NUMBER	(15)
ADJUSTED_DENORM_ID	NUMBER	(15)
BILLABLE_FLAG_1	VARCHAR2	(1)
BILLABLE_FLAG_2	VARCHAR2	(1)
BILLABLE_FLAG_3	VARCHAR2	(1)
BILLABLE_FLAG_4	VARCHAR2	(1)
BILLABLE_FLAG_5	VARCHAR2	(1)
BILLABLE_FLAG_6	VARCHAR2	(1)
BILLABLE_FLAG_7	VARCHAR2	(1)

Query Text

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


SELECT EXPENDITURE_ID
,      DENORM_ID
,      PERSON_ID
,      PROJECT_ID
,      TASK_ID
,      BILLABLE_FLAG
,      EXPENDITURE_TYPE
,      DEFAULT_SYS_LINK_FUNC
,      UNIT_OF_MEASURE_CODE
,      UNIT_OF_MEASURE
,      EXPENDITURE_ITEM_ID_1
,      EXPENDITURE_ITEM_DATE_1
,      QUANTITY_1
,      SYSTEM_LINKAGE_FUNCTION_1
,      NON_LABOR_RESOURCE_1
,      ORGANIZATION_ID_1
,      OVERRIDE_TO_ORGANIZATION_ID_1
,      RAW_COST_1
,      RAW_COST_RATE_1
,      ATTRIBUTE_CATEGORY_1
,      ATTRIBUTE1_1
,      ATTRIBUTE1_2
,      ATTRIBUTE1_3
,      ATTRIBUTE1_4
,      ATTRIBUTE1_5
,      ATTRIBUTE1_6
,      ATTRIBUTE1_7
,      ATTRIBUTE1_8
,      ATTRIBUTE1_9
,      ATTRIBUTE1_10
,      ORIG_TRANSACTION_REFERENCE_1
,      ADJUSTED_EXPENDITURE_ITEM_ID_1
,      NET_ZERO_ADJUSTMENT_FLAG_1
,      EXPENDITURE_COMMENT_1
,      EXPENDITURE_ITEM_ID_2
,      EXPENDITURE_ITEM_DATE_2
,      QUANTITY_2
,      SYSTEM_LINKAGE_FUNCTION_2
,      NON_LABOR_RESOURCE_2
,      ORGANIZATION_ID_2
,      OVERRIDE_TO_ORGANIZATION_ID_2
,      RAW_COST_2
,      RAW_COST_RATE_2
,      ATTRIBUTE_CATEGORY_2
,      ATTRIBUTE2_1
,      ATTRIBUTE2_2
,      ATTRIBUTE2_3
,      ATTRIBUTE2_4
,      ATTRIBUTE2_5
,      ATTRIBUTE2_6
,      ATTRIBUTE2_7
,      ATTRIBUTE2_8
,      ATTRIBUTE2_9
,      ATTRIBUTE2_10
,      ORIG_TRANSACTION_REFERENCE_2
,      ADJUSTED_EXPENDITURE_ITEM_ID_2
,      NET_ZERO_ADJUSTMENT_FLAG_2
,      EXPENDITURE_COMMENT_2
,      EXPENDITURE_ITEM_ID_3
,      EXPENDITURE_ITEM_DATE_3
,      QUANTITY_3
,      SYSTEM_LINKAGE_FUNCTION_3
,      NON_LABOR_RESOURCE_3
,      ORGANIZATION_ID_3
,      OVERRIDE_TO_ORGANIZATION_ID_3
,      RAW_COST_3
,      RAW_COST_RATE_3
,      ATTRIBUTE_CATEGORY_3
,      ATTRIBUTE3_1
,      ATTRIBUTE3_2
,      ATTRIBUTE3_3
,      ATTRIBUTE3_4
,      ATTRIBUTE3_5
,      ATTRIBUTE3_6
,      ATTRIBUTE3_7
,      ATTRIBUTE3_8
,      ATTRIBUTE3_9
,      ATTRIBUTE3_10
,      ORIG_TRANSACTION_REFERENCE_3
,      ADJUSTED_EXPENDITURE_ITEM_ID_3
,      NET_ZERO_ADJUSTMENT_FLAG_3
,      EXPENDITURE_COMMENT_3
,      EXPENDITURE_ITEM_ID_4
,      EXPENDITURE_ITEM_DATE_4
,      QUANTITY_4
,      SYSTEM_LINKAGE_FUNCTION_4
,      NON_LABOR_RESOURCE_4
,      ORGANIZATION_ID_4
,      OVERRIDE_TO_ORGANIZATION_ID_4
,      RAW_COST_4
,      RAW_COST_RATE_4
,      ATTRIBUTE_CATEGORY_4
,      ATTRIBUTE4_1
,      ATTRIBUTE4_2
,      ATTRIBUTE4_3
,      ATTRIBUTE4_4
,      ATTRIBUTE4_5
,      ATTRIBUTE4_6
,      ATTRIBUTE4_7
,      ATTRIBUTE4_8
,      ATTRIBUTE4_9
,      ATTRIBUTE4_10
,      ORIG_TRANSACTION_REFERENCE_4
,      ADJUSTED_EXPENDITURE_ITEM_ID_4
,      NET_ZERO_ADJUSTMENT_FLAG_4
,      EXPENDITURE_COMMENT_4
,      EXPENDITURE_ITEM_ID_5
,      EXPENDITURE_ITEM_DATE_5
,      QUANTITY_5
,      SYSTEM_LINKAGE_FUNCTION_5
,      NON_LABOR_RESOURCE_5
,      ORGANIZATION_ID_5
,      OVERRIDE_TO_ORGANIZATION_ID_5
,      RAW_COST_5
,      RAW_COST_RATE_5
,      ATTRIBUTE_CATEGORY_5
,      ATTRIBUTE5_1
,      ATTRIBUTE5_2
,      ATTRIBUTE5_3
,      ATTRIBUTE5_4
,      ATTRIBUTE5_5
,      ATTRIBUTE5_6
,      ATTRIBUTE5_7
,      ATTRIBUTE5_8
,      ATTRIBUTE5_9
,      ATTRIBUTE5_10
,      ORIG_TRANSACTION_REFERENCE_5
,      ADJUSTED_EXPENDITURE_ITEM_ID_5
,      NET_ZERO_ADJUSTMENT_FLAG_5
,      EXPENDITURE_COMMENT_5
,      EXPENDITURE_ITEM_ID_6
,      EXPENDITURE_ITEM_DATE_6
,      QUANTITY_6
,      SYSTEM_LINKAGE_FUNCTION_6
,      NON_LABOR_RESOURCE_6
,      ORGANIZATION_ID_6
,      OVERRIDE_TO_ORGANIZATION_ID_6
,      RAW_COST_6
,      RAW_COST_RATE_6
,      ATTRIBUTE_CATEGORY_6
,      ATTRIBUTE6_1
,      ATTRIBUTE6_2
,      ATTRIBUTE6_3
,      ATTRIBUTE6_4
,      ATTRIBUTE6_5
,      ATTRIBUTE6_6
,      ATTRIBUTE6_7
,      ATTRIBUTE6_8
,      ATTRIBUTE6_9
,      ATTRIBUTE6_10
,      ORIG_TRANSACTION_REFERENCE_6
,      ADJUSTED_EXPENDITURE_ITEM_ID_6
,      NET_ZERO_ADJUSTMENT_FLAG_6
,      EXPENDITURE_COMMENT_6
,      EXPENDITURE_ITEM_ID_7
,      EXPENDITURE_ITEM_DATE_7
,      QUANTITY_7
,      SYSTEM_LINKAGE_FUNCTION_7
,      NON_LABOR_RESOURCE_7
,      ORGANIZATION_ID_7
,      OVERRIDE_TO_ORGANIZATION_ID_7
,      RAW_COST_7
,      RAW_COST_RATE_7
,      ATTRIBUTE_CATEGORY_7
,      ATTRIBUTE7_1
,      ATTRIBUTE7_2
,      ATTRIBUTE7_3
,      ATTRIBUTE7_4
,      ATTRIBUTE7_5
,      ATTRIBUTE7_6
,      ATTRIBUTE7_7
,      ATTRIBUTE7_8
,      ATTRIBUTE7_9
,      ATTRIBUTE7_10
,      ORIG_TRANSACTION_REFERENCE_7
,      ADJUSTED_EXPENDITURE_ITEM_ID_7
,      NET_ZERO_ADJUSTMENT_FLAG_7
,      EXPENDITURE_COMMENT_7
,      DENORM_TOTAL_QTY
,      DENORM_TOTAL_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      JOB_ID_1
,      JOB_ID_2
,      JOB_ID_3
,      JOB_ID_4
,      JOB_ID_5
,      JOB_ID_6
,      JOB_ID_7
,      ADJUSTED_DENORM_ID
,      BILLABLE_FLAG_1
,      BILLABLE_FLAG_2
,      BILLABLE_FLAG_3
,      BILLABLE_FLAG_4
,      BILLABLE_FLAG_5
,      BILLABLE_FLAG_6
,      BILLABLE_FLAG_7
FROM PA.PA_EI_DENORM#;

Dependencies

[top of page]

PA.PA_EI_DENORM# references the following:

PA: PA_EI_DENORM

PA.PA_EI_DENORM# is referenced by following:

APPS: PA_EI_DENORM; PA_EI_DENORM_T1