[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSP_ENC_LINES# |
|---|---|
| Object Type: | VIEW |
| Owner: | PSP |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ENC_ELEMENT_TYPE_ID | NUMBER | (9) | Yes | |
| ENC_LINE_ID | NUMBER | (9) | Yes | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
| ENCUMBRANCE_DATE | DATE | Yes | ||
| DR_CR_FLAG | VARCHAR2 | (1) | Yes | |
| ENCUMBRANCE_AMOUNT | NUMBER | (10) | Yes | |
| ENC_LINE_TYPE | VARCHAR2 | (1) | Yes | |
| SCHEDULE_LINE_ID | NUMBER | (9) | ||
| ORG_SCHEDULE_ID | NUMBER | (9) | ||
| DEFAULT_ORG_ACCOUNT_ID | NUMBER | (10) | ||
| SUSPENSE_ORG_ACCOUNT_ID | NUMBER | (10) | ||
| ELEMENT_ACCOUNT_ID | NUMBER | (10) | ||
| GL_PROJECT_FLAG | VARCHAR2 | (1) | Yes | |
| ENC_SUMMARY_LINE_ID | NUMBER | (9) | ||
| PERSON_ID | NUMBER | (9) | Yes | |
| ASSIGNMENT_ID | NUMBER | (9) | Yes | |
| AWARD_ID | NUMBER | (10) | ||
| TASK_ID | NUMBER | (10) | ||
| EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | (10) | ||
| PROJECT_ID | NUMBER | (10) | ||
| GL_CODE_COMBINATION_ID | NUMBER | (15) | ||
| TIME_PERIOD_ID | NUMBER | (15) | Yes | |
| PAYROLL_ID | NUMBER | (9) | Yes | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
| DEFAULT_REASON_CODE | VARCHAR2 | (50) | ||
| SUSPENSE_REASON_CODE | VARCHAR2 | (50) | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| STATUS_CODE | VARCHAR2 | (1) | Yes | |
| ENC_CONTROL_ID | NUMBER | (10) | Yes | |
| CHANGE_FLAG | VARCHAR2 | (1) | ||
| ENC_START_DATE | DATE | |||
| ENC_END_DATE | DATE | |||
| PREV_EFFECTIVE_DATE | DATE | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| PAYROLL_ACTION_ID | NUMBER | |||
| ORIG_GL_CODE_COMBINATION_ID | NUMBER | (15) | ||
| ORIG_PROJECT_ID | NUMBER | (15) | ||
| ORIG_TASK_ID | NUMBER | (15) | ||
| ORIG_AWARD_ID | NUMBER | (15) | ||
| ORIG_EXPENDITURE_ORG_ID | NUMBER | (15) | ||
| ORIG_EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
| HIERARCHY_CODE | VARCHAR2 | (30) | ||
| HIERARCHY_START_DATE | DATE | |||
| HIERARCHY_END_DATE | DATE | |||
| PREV_ENC_END_DATE | DATE | |||
| PREV_ENCUMBRANCE_AMOUNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ENC_ELEMENT_TYPE_ID
, ENC_LINE_ID
, BUSINESS_GROUP_ID
, ENCUMBRANCE_DATE
, DR_CR_FLAG
, ENCUMBRANCE_AMOUNT
, ENC_LINE_TYPE
, SCHEDULE_LINE_ID
, ORG_SCHEDULE_ID
, DEFAULT_ORG_ACCOUNT_ID
, SUSPENSE_ORG_ACCOUNT_ID
, ELEMENT_ACCOUNT_ID
, GL_PROJECT_FLAG
, ENC_SUMMARY_LINE_ID
, PERSON_ID
, ASSIGNMENT_ID
, AWARD_ID
, TASK_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ORGANIZATION_ID
, PROJECT_ID
, GL_CODE_COMBINATION_ID
, TIME_PERIOD_ID
, PAYROLL_ID
, SET_OF_BOOKS_ID
, DEFAULT_REASON_CODE
, SUSPENSE_REASON_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, STATUS_CODE
, ENC_CONTROL_ID
, CHANGE_FLAG
, ENC_START_DATE
, ENC_END_DATE
, PREV_EFFECTIVE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, PAYROLL_ACTION_ID
, ORIG_GL_CODE_COMBINATION_ID
, ORIG_PROJECT_ID
, ORIG_TASK_ID
, ORIG_AWARD_ID
, ORIG_EXPENDITURE_ORG_ID
, ORIG_EXPENDITURE_TYPE
, HIERARCHY_CODE
, HIERARCHY_START_DATE
, HIERARCHY_END_DATE
, PREV_ENC_END_DATE
, PREV_ENCUMBRANCE_AMOUNT
FROM PSP.PSP_ENC_LINES#;
PSP
PSP_ENC_LINES
APPS
PSP_ENC_LINES
PSP_ENC_LINES_WHO
|
|
|
|