[Home] [Help] [Dependency Information]
Object Name: | AK_FLOW_REGION_RELATIONS |
---|---|
Object Type: | TABLE |
Owner: | AK |
FND Design Data: | AK.AK_FLOW_REGION_RELATIONS |
Subobject Name: | |
Status: | VALID |
AK_FLOW_REGION_RELATIONS defines the foreign key relationship
between two flow page regions. You will need one row for each
relationship that you want to create.
Each relationship must specify the flow, the "From" (parent) page
region, the "To" (child) page region and the foreign key that links
the "From" (parent) page region to the "To" (child) page region.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AK_FLOW_REGION_RELATIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FLOW_CODE
FLOW_APPLICATION_ID FOREIGN_KEY_NAME FROM_PAGE_CODE FROM_PAGE_APPL_ID FROM_REGION_CODE FROM_REGION_APPL_ID TO_PAGE_CODE TO_PAGE_APPL_ID TO_REGION_CODE TO_REGION_APPL_ID |
AK_FLOW_REGION_RELATIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FOREIGN_KEY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FLOW_CODE | VARCHAR2 | (30) | Yes | Flow unique identifier |
FLOW_APPLICATION_ID | NUMBER | (15) | Yes | Product team's application ID which the flow belong to |
FOREIGN_KEY_NAME | VARCHAR2 | (30) | Yes | Name of foreign key relationship between the from flow page region and the to flow page region |
FROM_PAGE_CODE | VARCHAR2 | (30) | Yes | From flow page identifier |
FROM_PAGE_APPL_ID | NUMBER | (15) | Yes | Product team's application ID which the from flow page belong to |
FROM_REGION_CODE | VARCHAR2 | (30) | Yes | From flow page region identifier |
FROM_REGION_APPL_ID | NUMBER | (15) | Yes | Product team's application ID which the from flow page region belong to |
TO_PAGE_CODE | VARCHAR2 | (30) | Yes | Destination flow page identifier |
TO_PAGE_APPL_ID | NUMBER | (15) | Yes | Product team's application ID which the destination flow page belong to |
TO_REGION_CODE | VARCHAR2 | (30) | Yes | Destination flow page region identifier |
TO_REGION_APPL_ID | NUMBER | (15) | Yes | Product team's application ID which the destination flow page region belong to |
APPLICATION_ID | NUMBER | (15) | Yes | Application ID of product team who defined this flow page region relation |
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 | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT FLOW_CODE
, FLOW_APPLICATION_ID
, FOREIGN_KEY_NAME
, FROM_PAGE_CODE
, FROM_PAGE_APPL_ID
, FROM_REGION_CODE
, FROM_REGION_APPL_ID
, TO_PAGE_CODE
, TO_PAGE_APPL_ID
, TO_REGION_CODE
, TO_REGION_APPL_ID
, APPLICATION_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM AK.AK_FLOW_REGION_RELATIONS;
AK.AK_FLOW_REGION_RELATIONS does not reference any database object
AK.AK_FLOW_REGION_RELATIONS is referenced by following:
|
|
|