[Home] [Help] [Dependency Information]
Object Name: | PSB_BUDGET_WORKFLOW_RULES |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_BUDGET_WORKFLOW_RULES |
Subobject Name: | |
Status: | VALID |
PSB_BUDGET_WORKFLOW_RULES stores information about the rules to be
used for review group purposes in the budget submission process.
Workflow rules are defined for a budget group hierarchy. The rules are
defined using three components:
1) Budget groups this rule applies to. This is identified using
the budget group category. This includes all budget groups in the
category assigned to the rule.
2) Accounts or positions that are applicable to the rule. This
includes all account sets or position sets assigned to this rule.
3) Person to be notified if there are conditions that satisfy the
rule. This is the review group assigned to this rule.
Notification can be for informational purposes only or may require
approval before a worksheet can progress to the next stage.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_BUDGET_WORKFLOW_RULES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BUDGET_WORKFLOW_RULE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUDGET_WORKFLOW_RULE_ID | NUMBER | (20) | Yes | Workflow rule unique identifier |
NAME | VARCHAR2 | (80) | Yes | Workflow rule name |
BUDGET_GROUP_ID | NUMBER | (20) | Yes | Budget group unique identifier for the budget group hierarchy for which this rule is defined |
STAGE_ID | NUMBER | (15) | Yes | Budget stage unique identifier of budget type W. Initiation budget group. |
OVERRIDE_STAGE_ID | NUMBER | (15) | Budget stage unique identifier of budget type W. For future use. | |
REVIEW_BUDGET_GROUP_ID | NUMBER | (30) | Authorization budget group to which the worksheet must be routed if there are lines which satisfy the conditions of this rule | |
APPROVAL_OPTION | VARCHAR2 | (1) | Yes | Flag indicates if this rule requires approval from review group or if it is for informational purposes only |
DESCRIPTION | VARCHAR2 | (240) | Rule description | |
ACCOUNT_OR_POSITION_TYPE | VARCHAR2 | (1) | Flag indicates if this rule is for an account or a position set | |
DATA_EXTRACT_ID | NUMBER | (20) | Data extract identifier when POSITION_SET_FLAG is Y | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
CREATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context |
Cut, paste (and edit) the following text to query this object:
SELECT BUDGET_WORKFLOW_RULE_ID
, NAME
, BUDGET_GROUP_ID
, STAGE_ID
, OVERRIDE_STAGE_ID
, REVIEW_BUDGET_GROUP_ID
, APPROVAL_OPTION
, DESCRIPTION
, ACCOUNT_OR_POSITION_TYPE
, DATA_EXTRACT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, CONTEXT
FROM PSB.PSB_BUDGET_WORKFLOW_RULES;
PSB.PSB_BUDGET_WORKFLOW_RULES does not reference any database object
PSB.PSB_BUDGET_WORKFLOW_RULES is referenced by following:
|
|
|