[Home] [Help] [Dependency Information]
Object Name: | PV_GE_TEMP_APPROVERS |
---|---|
Object Type: | TABLE |
Owner: | PV |
FND Design Data: | PV.PV_GE_TEMP_APPROVERS |
Subobject Name: | |
Status: | VALID |
PV_GE_TEMP_APPROVERS is PRM's one of the Global Entitiy tables. It stores details of approver who needs to approve a given entity, when AME product is used for approval processing. It contains TEMP word because it stores the inermediate approver details temporarily, and only the final approver details are persistent.
Enrollment requests entity uses this table to capture the approver details, which are returned from AME after determining as per approval rules.
ARC_APPR_FOR_ENTITY_CODE stores the entity code, and APPR_FOR_ENTITY_ID stores the entity identifier.
Approver can be of different types - Person, User, or Resource. APPROVER_TYPE_CODE determines this, and APPROVER_ID would be person_id, user_id or resource_id respectively.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PV_GE_TEMP_APPROVERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ENTITY_APPROVER_ID |
PV_GE_TEMP_APPROVERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ARC_APPR_FOR_ENTITY_CODE
APPR_FOR_ENTITY_ID APPROVER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENTITY_APPROVER_ID | NUMBER | Yes | Unique Identifier | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | This column is used for locking purposes |
ARC_APPR_FOR_ENTITY_CODE | VARCHAR2 | (30) | Yes | Entity code which needs approval - lookup |
APPR_FOR_ENTITY_ID | NUMBER | Yes | Entity Id that needs approval - Foreign key | |
APPROVER_ID | NUMBER | (15) | Approver Id - Person Id, User Id or Resource Id depending on approver type code - Foreign key | |
APPROVER_TYPE_CODE | VARCHAR2 | (30) | Approver Type, whether Person, User, or Resource - Lookup | |
APPROVAL_STATUS_CODE | VARCHAR2 | (30) | Yes | Approver response - whether approved, rejected, or pending, or default approver pending - Lookup |
WORKFLOW_ITEM_KEY | VARCHAR2 | (240) | Workflow item key | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ENTITY_APPROVER_ID
, OBJECT_VERSION_NUMBER
, ARC_APPR_FOR_ENTITY_CODE
, APPR_FOR_ENTITY_ID
, APPROVER_ID
, APPROVER_TYPE_CODE
, APPROVAL_STATUS_CODE
, WORKFLOW_ITEM_KEY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM PV.PV_GE_TEMP_APPROVERS;
PV.PV_GE_TEMP_APPROVERS does not reference any database object
PV.PV_GE_TEMP_APPROVERS is referenced by following:
|
|
|