[Home] [Help]
[Dependency Information]
Object Name: | JTF_AM_SKILL_RULES |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
This table contains the skill rule mapping with product, category, problem code and component. It will help in finiding the rule id for specific document type depending on whether product id, category id, problem code and component is passed or not.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_AM_SKILL_RULES_U1 | NORMAL | UNIQUE |
![]() |
![]() |
JTF_AM_SKILL_RULES_U2 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() ![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | Yes | Unique Identifier | |
DOCUMENT_TYPE | VARCHAR2 | (30) | Yes | Document type of the record |
PRODUCT_ID_PASSED | NUMBER | Yes | Column to check if Product Id is passed and has to be considered. Valid values '1' means Yes, '0' means No | |
CATEGORY_ID_PASSED | NUMBER | Yes | Column to check if Category Id is passed and has to be considered. Valid values '1' means Yes, '0' means No | |
PROBLEM_CODE_PASSED | NUMBER | Yes | Column to check if Problem Code is passed and has to be considered. Valid values '1' means Yes, '0' means No | |
COMPONENT_ID_PASSED | NUMBER | Yes | Column to check if Component Id is passed and has to be considered. Valid values '1' means Yes, '0' means No | |
ACTIVE_FLAG | VARCHAR2 | (10) | Yes | Column to check if record is active. Valid values are Y and N. |
CREATED_BY | NUMBER | Yes | Standard Who Column | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Attribute Category | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
SECURITY_GROUP_ID | NUMBER | Security Group Id |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_ID
, DOCUMENT_TYPE
, PRODUCT_ID_PASSED
, CATEGORY_ID_PASSED
, PROBLEM_CODE_PASSED
, COMPONENT_ID_PASSED
, ACTIVE_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
FROM JTF.JTF_AM_SKILL_RULES;
JTF.JTF_AM_SKILL_RULES does not reference any database object
JTF.JTF_AM_SKILL_RULES is referenced by following:
|
|
|