[Home] [Help] [Dependency Information]
Object Name: | AS_ACCESSES_ALL_LEAD_TEMP |
---|---|
Object Type: | TABLE |
Owner: | OSM |
Subobject Name: | |
Status: | VALID |
Intermediate table to process Sales Lead data. Used during ASN upgrade process
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALES_LEAD_ID | NUMBER | Sales Lead Identifier | ||
CODE_ACCESS_ID | VARCHAR2 | (28) | Access Identifie | |
SALESFORCE_ID | NUMBER | SalesForce Identifier | ||
SALES_GROUP_ID | NUMBER | Group Id of this sales rep. | ||
FREEZE_FLAG | VARCHAR2 | (1) | Flag indicating whether the record is frozen | |
TEAM_LEADER_FLAG | VARCHAR2 | (1) | Team Leader Flag | |
OWNER_FLAG | VARCHAR2 | (1) | Flag indicating if the employee is the owner of a sales lead | |
CONTRIBUTOR_FLAG | VARCHAR2 | (1) | Flag indicating if the employee is the contributor of a opportunity |
Cut, paste (and edit) the following text to query this object:
SELECT SALES_LEAD_ID
, CODE_ACCESS_ID
, SALESFORCE_ID
, SALES_GROUP_ID
, FREEZE_FLAG
, TEAM_LEADER_FLAG
, OWNER_FLAG
, CONTRIBUTOR_FLAG
FROM OSM.AS_ACCESSES_ALL_LEAD_TEMP;
OSM.AS_ACCESSES_ALL_LEAD_TEMP does not reference any database object
OSM.AS_ACCESSES_ALL_LEAD_TEMP is referenced by following:
|
|
|