Skip to content

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 Comments
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)
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:

SchemaPA
TablePA_EI_DENORM
PA.PA_EI_DENORM# is referenced by following:

SchemaAPPS
SynonymPA_EI_DENORM
TriggerPA_EI_DENORM_T1