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

TABLE: MSC.MSC_X_SECURITY_RULES

Object Details
Object Name: MSC_X_SECURITY_RULES
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_X_SECURITY_RULES
Subobject Name:
Status: VALID


This table contains the security rules for processing data in Oracle Collaborative planning.
This table is populated by the Define Security rules page in the Oracle Collaborative planning
product. Data in this table is used to restrict views and updates of records seen in
the different screens in the Oracle Collaborative planning product.
The rules can be assigned at different levels e.g company, item, order type etc.
Certain rules are seeded into this table by Oracle APS.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Yes Rule identifier
ORDER_TYPE NUMBER

Order type
ORDER_TYPE_MEANING VARCHAR2 (80)
Order type meaning
ITEM_ID NUMBER

Inventory item identifier
ITEM_NAME VARCHAR2 (750)
Item name
CATEGORY_ID NUMBER

Category identifier
CATEGORY_NAME VARCHAR2 (200)
Category name
CUSTOMER_ID NUMBER

Customer identifier
SUPPLIER_ID NUMBER

Supplier identifier
CUSTOMER_SITE_ID NUMBER

Customer site identifier
SUPPLIER_SITE_ID NUMBER

Supplier site identifier
ORG_ID NUMBER

Organization identifier
ORDER_NUMBER VARCHAR2 (50)
Order number
GRANTEE_TYPE VARCHAR2 (30) Yes Grantee type
GRANTEE_KEY NUMBER

Grantee key
PRIVILEGE VARCHAR2 (12) Yes Privilege
COMPANY_ID NUMBER

Company identifier
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_ID NUMBER

Concurrent Who column
EFFECTIVE_FROM_DATE DATE

Effective from date
EFFECTIVE_TO_DATE DATE

Effective to date
Query Text

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


SELECT RULE_ID
,      ORDER_TYPE
,      ORDER_TYPE_MEANING
,      ITEM_ID
,      ITEM_NAME
,      CATEGORY_ID
,      CATEGORY_NAME
,      CUSTOMER_ID
,      SUPPLIER_ID
,      CUSTOMER_SITE_ID
,      SUPPLIER_SITE_ID
,      ORG_ID
,      ORDER_NUMBER
,      GRANTEE_TYPE
,      GRANTEE_KEY
,      PRIVILEGE
,      COMPANY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      EFFECTIVE_FROM_DATE
,      EFFECTIVE_TO_DATE
FROM MSC.MSC_X_SECURITY_RULES;

Dependencies

[top of page]

MSC.MSC_X_SECURITY_RULES does not reference any database object

MSC.MSC_X_SECURITY_RULES is referenced by following:

SchemaAPPS
SynonymMSC_X_SECURITY_RULES