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

VIEW: PV.PV_ACCESS_MIGRATION_LOG#

Object Details
Object Name: PV_ACCESS_MIGRATION_LOG#
Object Type: VIEW
Owner: PV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCESS_MIGRATION_LOG_ID NUMBER (30)
ACCESS_ID NUMBER (30) Yes
ACTION VARCHAR2 (240)
CREATION_DATE DATE

ACCESS_TYPE VARCHAR2 (240)
FREEZE_FLAG VARCHAR2 (240)
REASSIGN_FLAG VARCHAR2 (240)
TEAM_LEADER_FLAG VARCHAR2 (240)
CUSTOMER_ID NUMBER (30)
ADDRESS_ID NUMBER (30)
SALESFORCE_ID NUMBER (30)
PARTNER_CUSTOMER_ID NUMBER

PARTNER_ADDRESS_ID NUMBER (30)
LEAD_ID NUMBER (30)
SALESFORCE_ROLE_CODE VARCHAR2 (240)
ORG_ID NUMBER (30)
SALES_GROUP_ID NUMBER (30)
INTERNAL_UPDATE_ACCESS NUMBER (30)
SALES_LEAD_ID NUMBER (30)
PARTNER_CONT_PARTY_ID NUMBER (30)
OWNER_FLAG VARCHAR2 (240)
CREATED_BY_TAP_FLAG VARCHAR2 (240)
PRM_KEEP_FLAG VARCHAR2 (240)
OPEN_FLAG VARCHAR2 (240)
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# references the following:

SchemaPV
TablePV_ACCESS_MIGRATION_LOG
PV.PV_ACCESS_MIGRATION_LOG# is referenced by following:

SchemaAPPS
SynonymPV_ACCESS_MIGRATION_LOG