[Home] [Help] [Dependency Information]
Object Name: | PA_EI_DENORM# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
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) | ||
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) |
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#;
|
|
|