eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PV.PV_ACCESS_MIGRATION_LOG

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

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

Query Text

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;

Dependencies

[top of page]

PV.PV_ACCESS_MIGRATION_LOG does not reference any database object

PV.PV_ACCESS_MIGRATION_LOG is referenced by following:

PV: PV_ACCESS_MIGRATION_LOG#