DBA Data[Home] [Help] [Dependency Information]

TABLE: BSC.BSC_RESPONSIBILITY

Object Details
Object Name: BSC_RESPONSIBILITY
Object Type: TABLE
Owner: BSC
FND Design Data: TableBSC.BSC_RESPONSIBILITY
Subobject Name:
Status: VALID


BSC_RESPONSIBILITY stores information about BSC responsibilities such as responsibility identifier, Application identifier, responsibility name, etc.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_RESPONSIBILITY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnRESPONSIBILITY_ID
BSC_RESPONSIBILITY_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESPONSIBILITY_KEY
ColumnAPPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Application identifier
RESPONSIBILITY_ID NUMBER (15) Yes Responsibility identifier
RESPONSIBILITY_NAME VARCHAR2 (100)
Responsibility name
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
DATA_GROUP_APPLICATION_ID NUMBER (15) Yes Data group application identifier
DATA_GROUP_ID NUMBER (15) Yes Data group identifier
FORM_APPLICATION_ID NUMBER (15)
Form application identifier
FORM_ID NUMBER (15)
Form identifier
MENU_APPLICATION_ID NUMBER (15)
Menu application identifier
MENU_ID NUMBER (15) Yes Menu identifier
RO_ORACLE_ID_ACCESS_FLAG VARCHAR2 (1)
Ro Oracle identifier access flag
TERM_SECURITY_ENABLED_FLAG VARCHAR2 (1)
Term security enabled flag
START_DATE DATE
Yes Start date
END_DATE DATE

End date
DESCRIPTION VARCHAR2 (240)
Description
GROUP_APPLICATION_ID NUMBER (15)
Group application identifier
REQUEST_GROUP_ID NUMBER (15)
Request group identifier
VERSION VARCHAR2 (1)
Version
WEB_HOST_NAME VARCHAR2 (80)
Web host name
WEB_AGENT_NAME VARCHAR2 (80)
Web agent name
RESPONSIBILITY_KEY VARCHAR2 (30) Yes Responsibilty key
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLICATION_ID
,      RESPONSIBILITY_ID
,      RESPONSIBILITY_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DATA_GROUP_APPLICATION_ID
,      DATA_GROUP_ID
,      FORM_APPLICATION_ID
,      FORM_ID
,      MENU_APPLICATION_ID
,      MENU_ID
,      RO_ORACLE_ID_ACCESS_FLAG
,      TERM_SECURITY_ENABLED_FLAG
,      START_DATE
,      END_DATE
,      DESCRIPTION
,      GROUP_APPLICATION_ID
,      REQUEST_GROUP_ID
,      VERSION
,      WEB_HOST_NAME
,      WEB_AGENT_NAME
,      RESPONSIBILITY_KEY
FROM BSC.BSC_RESPONSIBILITY;

Dependencies

[top of page]

BSC.BSC_RESPONSIBILITY does not reference any database object

BSC.BSC_RESPONSIBILITY is referenced by following:

SchemaAPPS
SynonymBSC_RESPONSIBILITY