[Home] [Help] [Dependency Information]
Object Name: | PN_REC_EXPCL_INC_ALL |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_REC_EXPCL_INC_ALL |
Subobject Name: | |
Status: | VALID |
Stores information regarding the space standard and recovery type of the locations that will be included when you run the Expense Class Details concurrent process for the Expense Class. This table is partitioned by organization
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_REC_EXPCL_INC_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EXPENSE_CLASS_INCLUSION_ID |
PN_REC_EXPCL_INC_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXPENSE_CLASS_TYPE_ID |
PN_REC_EXPCL_INC_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RECOVERY_SPACE_STD_CODE |
PN_REC_EXPCL_INC_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RECOVERY_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXPENSE_CLASS_INCLUSION_ID | NUMBER | (15) | Yes | Uniquely identifies the expense class inclusion row. |
EXPENSE_CLASS_TYPE_ID | NUMBER | (15) | Yes | Associates the expense class type row in PN_REC_EXPCL_TYPE_ALL with the expense class inclusion row. |
RECOVERY_SPACE_STD_CODE | VARCHAR2 | (30) | Yes | When you run the Expense Class Details concurrent process, expense class details are generated for the assignments associated with the locations with a specified space standard. |
RECOVERY_TYPE_CODE | VARCHAR2 | (30) | Yes | When you run the Expense Class Details concurrent process, expense class details are generated for the assignments associated with the locations with a specified recovery type. |
CLS_INCL_SHARE_PCT | NUMBER | The value of the Share % field is defaulted in the PN_REC_EXPCL_DTLACC_ALL table when you run the Expense Class Details concurrent process. The Share % and Fee % Before Contributors amounts are applied to the recoverable expense amount to compute the actual recoverable amount. The value of the Share % field should be between 0 and 100. | ||
CLS_INCL_FEE_BEFORE_CONTR | NUMBER | The value of the Fee % Before Contributors is defaulted in the PN_REC_EXPCL_DTLACC_ALL table when you run the Expense Class Details concurrent process. | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield segment. | |
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) | Operating unit identifier. |
Cut, paste (and edit) the following text to query this object:
SELECT EXPENSE_CLASS_INCLUSION_ID
, EXPENSE_CLASS_TYPE_ID
, RECOVERY_SPACE_STD_CODE
, RECOVERY_TYPE_CODE
, CLS_INCL_SHARE_PCT
, CLS_INCL_FEE_BEFORE_CONTR
, 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_EXPCL_INC_ALL;
PN.PN_REC_EXPCL_INC_ALL does not reference any database object
PN.PN_REC_EXPCL_INC_ALL is referenced by following:
|
|
|