[Home] [Help]
[Dependency Information]
Object Name: | MSD_APP_INSTANCE_ORGS |
---|---|
Object Type: | TABLE |
Owner: | MSD |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
This table resides in Source Instance. It hold the list of organizations for which data must be brought in to the planning Server. ODP source view restrict data using this table.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSD_APP_INSTANCE_ORGS_PK | NORMAL | UNIQUE |
![]() |
![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTANCE_ID | NUMBER | Yes | Source Instance ID | |
ORGANIZATION_ID | NUMBER | Yes | Source Organization ID | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column. | |
CREATION_DATE | DATE | Yes | Standard Who Column. | |
CREATED_BY | NUMBER | Yes | Standard Who Column. | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column. | ||
REQUEST_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who Column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment |
Cut, paste (and edit) the following text to query this object:
SELECT INSTANCE_ID
, ORGANIZATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM MSD.MSD_APP_INSTANCE_ORGS;
MSD.MSD_APP_INSTANCE_ORGS does not reference any database object
MSD.MSD_APP_INSTANCE_ORGS is referenced by following:
|
|
|