[Home] [Help] [Dependency Information]
Object Name: | AS_ACCESSES_ALL_OPP_TEMP |
---|---|
Object Type: | TABLE |
Owner: | OSM |
Subobject Name: | |
Status: | VALID |
Intermediate table to process Opportunity data. Used during ASN upgrade process
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEAD_ID | NUMBER | Lead Identifier | ||
CODE_ACCESS_ID | VARCHAR2 | (28) | Access Identifier | |
SALESFORCE_ID | NUMBER | Salesforce Identifier | ||
SALES_GROUP_ID | NUMBER | Group id of this sales rep. | ||
PARTNER_CUSTOMER_ID | NUMBER | Partner customer identifier | ||
PARTNER_CONT_PARTY_ID | NUMBER | Partner contact party id. Used by PRM | ||
FREEZE_FLAG | VARCHAR2 | (1) | Flag indicating whether the record is frozen | |
TEAM_LEADER_FLAG | VARCHAR2 | (1) | Flag indicating if the employee is a team leader of a opportunity | |
OWNER_FLAG | VARCHAR2 | (1) | Flag indicating if the employee is the owner of a opportunity | |
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 LEAD_ID
, CODE_ACCESS_ID
, SALESFORCE_ID
, SALES_GROUP_ID
, PARTNER_CUSTOMER_ID
, PARTNER_CONT_PARTY_ID
, FREEZE_FLAG
, TEAM_LEADER_FLAG
, OWNER_FLAG
, CONTRIBUTOR_FLAG
FROM OSM.AS_ACCESSES_ALL_OPP_TEMP;
OSM.AS_ACCESSES_ALL_OPP_TEMP does not reference any database object
OSM.AS_ACCESSES_ALL_OPP_TEMP is referenced by following:
|
|
|