[Home] [Help] [Dependency Information]
Object Name: | AS_TERR_RESOURCES_TMP |
---|---|
Object Type: | TABLE |
Owner: | OSM |
FND Design Data: | AS.AS_TERR_RESOURCES_TMP |
Subobject Name: | |
Status: | VALID |
Territory assignment result temporary table.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AS_TERR_RESOURCES_TMP_U1 | NORMAL | UNIQUE | APPS_TS_NOLOGGING |
TERR_ID
RESOURCE_ID RESOURCE_GROUP_ID PARTY_ID PARTY_SITE_ID LEAD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_ID | NUMBER | Yes | Party identifier | |
PARTY_SITE_ID | NUMBER | Party site identifier | ||
LEAD_ID | NUMBER | Opportunity identifier | ||
TERR_ID | NUMBER | Yes | Territory identifier | |
RESOURCE_ID | NUMBER | Yes | Resource identifier | |
RESOURCE_TYPE | VARCHAR2 | (60) | Yes | Resource type |
RESOURCE_GROUP_ID | NUMBER | Group identifier | ||
FULL_ACCESS_FLAG | VARCHAR2 | (1) | Full access flag | |
REQUEST_ID | NUMBER | Request identifier of last concurrent program to update record | ||
PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update record | ||
PROGRAM_ID | NUMBER | Identifier of last concurrent program to update record | ||
PROGRAM_UPDATE_DATE | DATE | Last date concurrent program updated record | ||
SECURITY_GROUP_ID | NUMBER | Subscriber id, for CRM Online Services use |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_ID
, PARTY_SITE_ID
, LEAD_ID
, TERR_ID
, RESOURCE_ID
, RESOURCE_TYPE
, RESOURCE_GROUP_ID
, FULL_ACCESS_FLAG
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SECURITY_GROUP_ID
FROM OSM.AS_TERR_RESOURCES_TMP;
OSM.AS_TERR_RESOURCES_TMP does not reference any database object
OSM.AS_TERR_RESOURCES_TMP is referenced by following:
|
|
|