[Home] [Help] [Dependency Information]
Object Name: | PV_ACCESS_MIGRATION_LOG |
---|---|
Object Type: | TABLE |
Owner: | PV |
FND Design Data: | PV.PV_ACCESS_MIGRATION_LOG |
Subobject Name: | |
Status: | VALID |
Stores the external sales team migration rows
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCESS_MIGRATION_LOG_ID | NUMBER | (30) | Primary Key for this table | |
ACCESS_ID | NUMBER | (30) | Yes | Access Id from as_accesses_all table |
ACTION | VARCHAR2 | (240) | Stores the action to be performed on as_accesses_all table | |
CREATION_DATE | DATE | Standard WHO Column | ||
ACCESS_TYPE | VARCHAR2 | (240) | Access Type in as_accesses_all | |
FREEZE_FLAG | VARCHAR2 | (240) | Freeze flag in as_accesses_all | |
REASSIGN_FLAG | VARCHAR2 | (240) | reassign flag in as_accesses_all | |
TEAM_LEADER_FLAG | VARCHAR2 | (240) | team_leader_flag in as_accesses_all | |
CUSTOMER_ID | NUMBER | (30) | customer id in as_accesses_all | |
ADDRESS_ID | NUMBER | (30) | Address ID in as_accesses_all | |
SALESFORCE_ID | NUMBER | (30) | Sales Force Id in as_accesses_all | |
PARTNER_CUSTOMER_ID | NUMBER | Partner Customer ID in as_accesses_all | ||
PARTNER_ADDRESS_ID | NUMBER | (30) | Partner Address ID in as_accesses_all | |
LEAD_ID | NUMBER | (30) | Opportunity ID from as_accesses_all | |
SALESFORCE_ROLE_CODE | VARCHAR2 | (240) | Salesforce Role Code in as_accesses_all | |
ORG_ID | NUMBER | (30) | Salesforce Role Code in as_accesses_all | |
SALES_GROUP_ID | NUMBER | (30) | Sales Group Id in as_accesses_all | |
INTERNAL_UPDATE_ACCESS | NUMBER | (30) | Internal Update Access from as_accesses_all | |
SALES_LEAD_ID | NUMBER | (30) | Lead Id from as_accesses_all | |
PARTNER_CONT_PARTY_ID | NUMBER | (30) | Partner Contact Party ID | |
OWNER_FLAG | VARCHAR2 | (240) | Owner Flag | |
CREATED_BY_TAP_FLAG | VARCHAR2 | (240) | Created By TAP Flag | |
PRM_KEEP_FLAG | VARCHAR2 | (240) | PRM Keep Flag | |
OPEN_FLAG | VARCHAR2 | (240) | Open Flag |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_MIGRATION_LOG_ID
, ACCESS_ID
, ACTION
, CREATION_DATE
, ACCESS_TYPE
, FREEZE_FLAG
, REASSIGN_FLAG
, TEAM_LEADER_FLAG
, CUSTOMER_ID
, ADDRESS_ID
, SALESFORCE_ID
, PARTNER_CUSTOMER_ID
, PARTNER_ADDRESS_ID
, LEAD_ID
, SALESFORCE_ROLE_CODE
, ORG_ID
, SALES_GROUP_ID
, INTERNAL_UPDATE_ACCESS
, SALES_LEAD_ID
, PARTNER_CONT_PARTY_ID
, OWNER_FLAG
, CREATED_BY_TAP_FLAG
, PRM_KEEP_FLAG
, OPEN_FLAG
FROM PV.PV_ACCESS_MIGRATION_LOG;
PV.PV_ACCESS_MIGRATION_LOG does not reference any database object
PV.PV_ACCESS_MIGRATION_LOG is referenced by following:
|
|
|