[Home] [Help] [Dependency Information]
Object Name: | PN_REC_ARCL_EXC_ALL |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_REC_ARCL_EXC_ALL |
Subobject Name: | |
Status: | VALID |
Stores the Exclusions information for an area class for
recovery setup. The exclusions will be deducted from the recoverable area
before calculating the recovery expenses. This table is partitioned by
organization.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_REC_ARCL_EXC_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | AREA_CLASS_EXCLUSION_ID |
PN_REC_ARCL_EXC_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | AREA_CLASS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AREA_CLASS_EXCLUSION_ID | NUMBER | (15) | Yes | Uniquely identifies an area class exclusion |
AREA_CLASS_ID | NUMBER | (15) | Yes | Identifies the area class row associated with this row |
RECOVERY_TYPE_CODE | VARCHAR2 | (30) | Recovery type code. Populated using the lookup PN_RECOVERY_TYPE | |
RECOVERY_SPACE_STD_CODE | VARCHAR2 | (30) | Recovery space standard. Populated using the lookup PN_RECOVERY_SPACE_STD_TYPE | |
EXCLUSION_TYPE_CODE | VARCHAR2 | (30) | Exclusion type. Indicates the type of exclusion. Populated using the lookup PN_AREA_CLASS_EXCLUSION_TYPE | |
RELATIONAL_CODE | VARCHAR2 | (30) | Relational code. Provides the condition for excluding locations along with the area. Populated using the lookup PN_AREA_CLASS_RELATION_TYPE | |
AREA | NUMBER | Provides the condition for excluding Locations along with the relational code | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition 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 | |
ORG_ID | NUMBER | (15) | Organization identifier |
Cut, paste (and edit) the following text to query this object:
SELECT AREA_CLASS_EXCLUSION_ID
, AREA_CLASS_ID
, RECOVERY_TYPE_CODE
, RECOVERY_SPACE_STD_CODE
, EXCLUSION_TYPE_CODE
, RELATIONAL_CODE
, AREA
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
FROM PN.PN_REC_ARCL_EXC_ALL;
PN.PN_REC_ARCL_EXC_ALL does not reference any database object
PN.PN_REC_ARCL_EXC_ALL is referenced by following:
|
|
|