[Home] [Help] [Dependency Information]
Object Name: | QP_SOURCESYSTEM_FNAREA_MAP |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_SOURCESYSTEM_FNAREA_MAP |
Subobject Name: | |
Status: | VALID |
Stores the functional areas for PTE/Source System Code combinations
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_SOURCESYSTEM_FNAREA_MAP_PK | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PTE_SOURCESYSTEM_FNAREA_ID |
QP_SOURCESYSTEM_FNAREA_MAP_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PTE_SOURCE_SYSTEM_ID
FUNCTIONAL_AREA_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PTE_SOURCESYSTEM_FNAREA_ID | NUMBER | Yes | Entity identifier | |
PTE_SOURCE_SYSTEM_ID | NUMBER | Yes | Indicates the PTE/Source System combination | |
FUNCTIONAL_AREA_ID | NUMBER | Yes | Indicates the functional area identifier | |
ENABLED_FLAG | VARCHAR2 | (1) | Indicates that the category set for the functional area is enabled and the pricing setups will allow category sets based on this functional area. Only categories belonging to category sets of enabeld functional areas will be sourced. | |
SEEDED_FLAG | VARCHAR2 | (1) | Indicates if the mapping is seeded or not. Seeded flags are defauted to Y for seeded mappings and NOT for user created mappings. It is not updateable by the user. | |
CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
REQUEST_ID | NUMBER | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT PTE_SOURCESYSTEM_FNAREA_ID
, PTE_SOURCE_SYSTEM_ID
, FUNCTIONAL_AREA_ID
, ENABLED_FLAG
, SEEDED_FLAG
, CONTEXT
, 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
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
FROM QP.QP_SOURCESYSTEM_FNAREA_MAP;
QP.QP_SOURCESYSTEM_FNAREA_MAP does not reference any database object
QP.QP_SOURCESYSTEM_FNAREA_MAP is referenced by following:
|
|
|