[Home] [Help] [Dependency Information]
Object Name: | AS_TERR_RESOURCES_TMP# |
---|---|
Object Type: | VIEW |
Owner: | OSM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_ID | NUMBER | Yes | ||
PARTY_SITE_ID | NUMBER | |||
LEAD_ID | NUMBER | |||
TERR_ID | NUMBER | Yes | ||
RESOURCE_ID | NUMBER | Yes | ||
RESOURCE_TYPE | VARCHAR2 | (60) | Yes | |
RESOURCE_GROUP_ID | NUMBER | |||
FULL_ACCESS_FLAG | VARCHAR2 | (1) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
SECURITY_GROUP_ID | NUMBER |
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#;
|
|
|