[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | LNS_DISTRIBUTIONS# |
|---|---|
| Object Type: | VIEW |
| Owner: | LNS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DISTRIBUTION_ID | NUMBER | (15) | Yes | |
| CODE_COMBINATION_ID | NUMBER | (15) | Yes | |
| LOAN_ID | NUMBER | (15) | Yes | |
| DISB_HEADER_ID | NUMBER | (15) | ||
| DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
| LINE_TYPE | VARCHAR2 | (30) | Yes | |
| ACCOUNT_NAME | VARCHAR2 | (30) | Yes | |
| ACCOUNT_TYPE | VARCHAR2 | (30) | Yes | |
| DISTRIBUTION_PERCENT | NUMBER | Yes | ||
| DISTRIBUTION_AMOUNT | NUMBER | |||
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
| FEE_ID | NUMBER | (15) | ||
| EVENT_ID | NUMBER | (15) | ||
| POSTED_FLAG | VARCHAR2 | (1) | ||
| START_DATE_ACTIVE | DATE | |||
| END_DATE_ACTIVE | DATE | |||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
| 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) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ATTRIBUTE16 | VARCHAR2 | (150) | ||
| ATTRIBUTE17 | VARCHAR2 | (150) | ||
| ATTRIBUTE18 | VARCHAR2 | (150) | ||
| ATTRIBUTE19 | VARCHAR2 | (150) | ||
| ATTRIBUTE20 | VARCHAR2 | (150) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| LOAN_AMOUNT_ADJ_ID | NUMBER | (15) | ||
| LOAN_LINE_ID | NUMBER | (15) | ||
| ACTIVITY | VARCHAR2 | (30) | ||
| ACCRUAL_PERIOD | VARCHAR2 | (15) | ||
| ACCRUAL_DATE | DATE | |||
| ACCRUAL_COMPLETED_FLAG | VARCHAR2 | (1) | ||
| PROJECT_ID | NUMBER | |||
| TASK_ID | NUMBER | |||
| EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
| AWARD_ID | NUMBER | |||
| EXPENDITURE_ITEM_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT DISTRIBUTION_ID
, CODE_COMBINATION_ID
, LOAN_ID
, DISB_HEADER_ID
, DISTRIBUTION_TYPE
, LINE_TYPE
, ACCOUNT_NAME
, ACCOUNT_TYPE
, DISTRIBUTION_PERCENT
, DISTRIBUTION_AMOUNT
, USSGL_TRANSACTION_CODE
, FEE_ID
, EVENT_ID
, POSTED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, LAST_UPDATE_LOGIN
, LOAN_AMOUNT_ADJ_ID
, LOAN_LINE_ID
, ACTIVITY
, ACCRUAL_PERIOD
, ACCRUAL_DATE
, ACCRUAL_COMPLETED_FLAG
, PROJECT_ID
, TASK_ID
, EXPENDITURE_TYPE
, AWARD_ID
, EXPENDITURE_ITEM_DATE
FROM LNS.LNS_DISTRIBUTIONS#;
LNS
LNS_DISTRIBUTIONS
APPS
LNS_DISTRIBUTIONS
|
|
|
|