[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_SECURITY_RULES |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_SECURITY_RULES
|
| Subobject Name: | |
| Status: | VALID |
This table is not used.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RULE_ID | NUMBER | Yes | Rule identifier | |
| GRANTEE_TYPE | VARCHAR2 | (30) | Yes | Grantee type |
| PRIVILEGE | VARCHAR2 | (12) | Yes | Privilege |
| ORDER_TYPE | NUMBER | Order type | ||
| SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||
| ITEM_ID | NUMBER | Inventory item identifier | ||
| ITEM_NAME | VARCHAR2 | (255) | 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_KEY | VARCHAR2 | (100) | Grantee key | |
| COMPANY_ID | NUMBER | Company identifier | ||
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | 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 | ||
| ORDER_TYPE_MEANING | VARCHAR2 | (30) | Order type meaning |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_ID
, GRANTEE_TYPE
, PRIVILEGE
, ORDER_TYPE
, SR_INSTANCE_ID
, ITEM_ID
, ITEM_NAME
, CATEGORY_ID
, CATEGORY_NAME
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_SITE_ID
, SUPPLIER_SITE_ID
, ORG_ID
, ORDER_NUMBER
, GRANTEE_KEY
, COMPANY_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, EFFECTIVE_FROM_DATE
, EFFECTIVE_TO_DATE
, ORDER_TYPE_MEANING
FROM MSC.MSC_SECURITY_RULES;
MSC.MSC_SECURITY_RULES does not reference any database object
MSC.MSC_SECURITY_RULES is referenced by following:
MSC
MSC_SECURITY_RULES#
|
|
|
|