[Home] [Help] [Dependency Information]
Object Name: | PV_ACCESS_MIGRATION_LOG# |
---|---|
Object Type: | VIEW |
Owner: | PV |
Subobject Name: | |
Status: | VALID |
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) |
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#;
|
|
|