[Home] [Help] [Dependency Information]
Object Name: | AS_RPT_ADMINS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AS.AS_RPT_ADMINS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMPLOYEE_PERSON_ID | NUMBER | Person identifier for admin/manager | ||
SALES_GROUP_ID | NUMBER | Yes | Group identifier for admin/manager | |
PARENT_SALES_GROUP_ID | NUMBER | Yes | Parent group id for admin/manager group | |
IMMEDIATE_PARENT_FLAG | VARCHAR2 | (1) | Yes | Flag indicating whether the value in PARENT_SALES_GROUP_ID is the identifier of the immediate parent sales group |
GRP_START_DATE_ACTIVE | DATE | Start active date of admin/manager group | ||
GRP_END_DATE_ACTIVE | DATE | End active date of admin/manager group | ||
SALESFORCE_ID | NUMBER | Yes | Resource id for admin/manager | |
TYPE | VARCHAR2 | (30) | Yes | Category of admin/manager |
ROLE_ID | NUMBER | Yes | Role id for admin/manager | |
ROLE_NAME | VARCHAR2 | (30) | Yes | Role name for admin/manager |
ROLE_TYPE_CODE | VARCHAR2 | (240) | Yes | Role type code for admin/manager |
MEMBER_FLAG | VARCHAR2 | (1) | Flag indicate this resource can be a member of a group | |
ADMIN_FLAG | VARCHAR2 | (1) | Flag indicate this resource can be an admin of a group | |
MANAGER_FLAG | VARCHAR2 | (1) | Flag indicate this resource can be a manager of a group | |
SF_START_DATE_ACTIVE | DATE | Yes | Start active date for admin/manager | |
SF_END_DATE_ACTIVE | DATE | End active date for admin/manager |
Cut, paste (and edit) the following text to query this object:
SELECT EMPLOYEE_PERSON_ID
, SALES_GROUP_ID
, PARENT_SALES_GROUP_ID
, IMMEDIATE_PARENT_FLAG
, GRP_START_DATE_ACTIVE
, GRP_END_DATE_ACTIVE
, SALESFORCE_ID
, TYPE
, ROLE_ID
, ROLE_NAME
, ROLE_TYPE_CODE
, MEMBER_FLAG
, ADMIN_FLAG
, MANAGER_FLAG
, SF_START_DATE_ACTIVE
, SF_END_DATE_ACTIVE
FROM APPS.AS_RPT_ADMINS_V;
|
|
|