[Home] [Help] [Dependency Information]
Object Name: | PQH_RULE_SETS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PQH.PQH_RULE_SETS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
Rules set View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
RULE_SET_ID | NUMBER | (10) | Yes | Primary Key |
REFERENCED_RULE_SET_ID | NUMBER | (10) | Reference Rule Set Identifier (self reference to PK) | |
ORGANIZATION_STRUCTURE_ID | NUMBER | (15) | Oraganization Hierarchy Identifier (Fk to per organization structures) | |
ORGANIZATION_ID | NUMBER | (15) | Oraganization Identifier (to be used when an org hiearchy is not associated) | |
BUSINESS_GROUP_ID | NUMBER | (15) | Business Group Identifier | |
RULE_LEVEL_CD | VARCHAR2 | (10) | Rule Level (Ignore / Warning / Error) | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object Version Number |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
RULE_SET_NAME | VARCHAR2 | (100) | Rule Set Name (User enterable, friendly name) | |
SHORT_NAME | VARCHAR2 | (30) | Yes | Developer Key with unique constraint to identify rule sets |
DESCRIPTION | VARCHAR2 | (240) | Details related to the Rule Set | |
RULE_APPLICABILITY | VARCHAR2 | (30) | Applicability identifies if the rule is a donor / receiver / none | |
STARTING_ORGANIZATION_ID | NUMBER | (15) | In case of Organization hierarchy, the organization to be treated as the first node | |
RULE_CATEGORY | VARCHAR2 | (30) | Rule category : Assignment Modification, Budget Preparation, Budget Reallocation , etc. | |
SEEDED_RULE_FLAG | VARCHAR2 | (10) | Flag that identifies if the Rule was seeded by oracle |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, RULE_SET_ID
, REFERENCED_RULE_SET_ID
, ORGANIZATION_STRUCTURE_ID
, ORGANIZATION_ID
, BUSINESS_GROUP_ID
, RULE_LEVEL_CD
, OBJECT_VERSION_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, RULE_SET_NAME
, SHORT_NAME
, DESCRIPTION
, RULE_APPLICABILITY
, STARTING_ORGANIZATION_ID
, RULE_CATEGORY
, SEEDED_RULE_FLAG
FROM APPS.PQH_RULE_SETS_VL;
|
|
|