[Home] [Help] [Dependency Information]
Object Name: | PV_GE_CHKLST_ITEMS_B |
---|---|
Object Type: | TABLE |
Owner: | PV |
FND Design Data: | PV.PV_GE_CHKLST_ITEMS_B |
Subobject Name: | |
Status: | VALID |
PV_GE_CHKLST_ITEMS_B is PRM's one of the Global Entitiy tables. It stores details of different check list items(tasks) that needs to be checked for an entity before it can be approved.
Programs entity uses this table to capture the details of tasks that need to be checked by an approver before approving the partner's enrollment request into a specific program.
ARC_USED_BY_ENTITY_CODE stores the entity code, and USED_BY_ENTITY_ID stores the entity identifier.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PV_GE_CHKLST_ITEMS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CHECKLIST_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHECKLIST_ITEM_ID | NUMBER | Yes | Unique Identifier | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | This column is used for locking purposes |
ARC_USED_BY_ENTITY_CODE | VARCHAR2 | (30) | Yes | Entity code for which cheklists needs to be checked - Lookup |
USED_BY_ENTITY_ID | NUMBER | Yes | Entity Id for which checklist items need to be checked - Foreign key. | |
SEQUENCE_NUM | NUMBER | Yes | Checklist Item sequence number | |
IS_REQUIRED_FLAG | VARCHAR2 | (1) | Yes | Is this checklist item mandatory for processing |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Whether checklist item is enabled or not |
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) | Standard WHO column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (240) | Attribute category | |
ATTRIBUTE1 | VARCHAR2 | (240) | Attribute1 | |
ATTRIBUTE2 | VARCHAR2 | (240) | Attribute2 | |
ATTRIBUTE3 | VARCHAR2 | (240) | Attribute3 | |
ATTRIBUTE4 | VARCHAR2 | (240) | Attribute4 | |
ATTRIBUTE5 | VARCHAR2 | (240) | Attribute5 | |
ATTRIBUTE6 | VARCHAR2 | (240) | Attribute6 | |
ATTRIBUTE7 | VARCHAR2 | (240) | Attribute7 | |
ATTRIBUTE8 | VARCHAR2 | (240) | Attribute8 | |
ATTRIBUTE9 | VARCHAR2 | (240) | Attribute9 | |
ATTRIBUTE10 | VARCHAR2 | (240) | Attribute10 | |
ATTRIBUTE11 | VARCHAR2 | (240) | Attribute11 | |
ATTRIBUTE12 | VARCHAR2 | (240) | Attribute12 | |
ATTRIBUTE13 | VARCHAR2 | (240) | Attribute13 | |
ATTRIBUTE14 | VARCHAR2 | (240) | Attribute14 | |
ATTRIBUTE15 | VARCHAR2 | (240) | Attribute15 |
Cut, paste (and edit) the following text to query this object:
SELECT CHECKLIST_ITEM_ID
, OBJECT_VERSION_NUMBER
, ARC_USED_BY_ENTITY_CODE
, USED_BY_ENTITY_ID
, SEQUENCE_NUM
, IS_REQUIRED_FLAG
, ENABLED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM PV.PV_GE_CHKLST_ITEMS_B;
PV.PV_GE_CHKLST_ITEMS_B does not reference any database object
PV.PV_GE_CHKLST_ITEMS_B is referenced by following:
|
|
|