[Home] [Help] [Dependency Information]
Object Name: | ZPB_DC_OBJECTS |
---|---|
Object Type: | TABLE |
Owner: | ZPB |
Subobject Name: | |
Status: | VALID |
This table stores the definition of templates and worksheets used in Data Collection. It also maintains the status of these objects.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZPB_DC_OBJECTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | OBJECT_ID |
ZPB_DC_OBJECTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TEMPLATE_ID |
ZPB_DC_OBJECTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OBJECT_USER_ID
OBJECT_TYPE |
ZPB_DC_OBJECTS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
APPROVER_USER_ID
OBJECT_TYPE |
ZPB_DC_OBJECTS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
STATUS
OBJECT_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_ID | NUMBER | Yes | Unique identifier for a template or worksheet object. | |
TEMPLATE_ID | NUMBER | Yes | Template Identifier. Stores the object identifier for the template. | |
ANALYSIS_CYCLE_ID | NUMBER | Yes | Business process identifier. | |
AC_INSTANCE_ID | NUMBER | Yes | Business process run identifier. | |
AC_TEMPLATE_ID | NUMBER | The template ID for this BP | ||
GENERATE_TEMPLATE_TASK_ID | NUMBER | Generate Template task id identifier. | ||
INSTRUCTION_TEXT_ID | NUMBER | Instruction text identifier. | ||
OBJECT_USER_ID | NUMBER | Yes | For template, this is the owner of the business process. For worksheet, this is the worksheet recipient. | |
DISTRIBUTOR_USER_ID | NUMBER | This column stores the user who distributes the template or the worksheets. | ||
APPROVER_USER_ID | NUMBER | The approver of the worksheet. Populated at the time of worksheet submission based on approver type. | ||
OBJECT_TYPE | VARCHAR2 | (1) | Yes | Type of Object: E for Editable copy of template object, M for Master template object , C for Worksheet object created for Process administrator, and W for Worksheet. |
TEMPLATE_NAME | VARCHAR2 | (680) | Yes | Name of the template generated for a particular business process run. |
USE_LAST_REVIEWED | VARCHAR2 | (1) | Indicates if the last reviewed template should be used to default the next generated template. | |
DESCRIPTION | VARCHAR2 | (240) | Long description of the template. | |
MULTIPLE_INPUT_LEVELS_FLAG | VARCHAR2 | (1) | Indicates if any line included in the template has multiple input levels. | |
DATAENTRY_OBJ_PATH | VARCHAR2 | (240) | Yes | Stores the path to the query object used to render the crosstab for the data entry worksheet or data entry template in the BI beans repository. |
DATAENTRY_OBJ_NAME | VARCHAR2 | (240) | Yes | Stores the name of query object used to render the crosstab for the data entry worksheet or its template in the BI beans repository. |
ENABLE_TARGET_FLAG | VARCHAR2 | (1) | Indicates if target setting is enabled in the template | |
TARGET_OBJ_PATH | VARCHAR2 | (240) | Yes | Stores the path to the query object used to render the crosstab for the target data entry or target template in the BI beans repository. |
TARGET_OBJ_NAME | VARCHAR2 | (240) | Yes | Stores the name of query object used to render the crosstab for the target data entry or its template in the BI beans repository. |
COPY_SOURCE_TYPE_FLAG | VARCHAR2 | (1) | Indicates if source type for line dimension members should be copied to personal AW. | |
CREATE_SOLVE_PROGRAM_FLAG | VARCHAR2 | (1) | Indicates if a solve program should be created. | |
PERSONAL_DATA_QUERY_FLAG | VARCHAR2 | (1) | Indicates if user has customized the data template layout distributed. | |
PERSONAL_TARGET_QUERY_FLAG | VARCHAR2 | (1) | Indicates if user's personal query should be overwritten with process administrator's template query. | |
STATUS | VARCHAR2 | (30) | Status of the worksheet or status of the worksheet. | |
APPROVAL_REQUIRED_FLAG | VARCHAR2 | (1) | Approval required flag: Y/N. This flag is always turned on for the cascade distribution method. Only when the Approval Required option is selected will this flag be turned on for the direct distribution method. | |
DEADLINE_DATE | DATE | The deadline date by which the worksheet should be submitted. | ||
DISTRIBUTION_METHOD | VARCHAR2 | (30) | Distribution method: Cascade or Direct | |
DISTRIBUTION_DIMENSION | VARCHAR2 | (50) | The dimension that used for distribution | |
DISTRIBUTION_HIERARCHY | VARCHAR2 | (240) | The hierarchy for the distribution dimension. | |
DISTRIBUTION_DATE | DATE | The date when the template or worksheet is distributed. | ||
SUBMISSION_DATE | DATE | The date the worksheet is submitted | ||
SUBMITTED_BY | NUMBER | (15) | The person who submitted the the worksheet. | |
WAIT_FOR_REVIEW_FLAG | VARCHAR2 | (1) | Indicates if Generate Template task should wait for the Process Administrator to review the template before transitioning to the next task in the business process. | |
REVIEW_COMPLETE_FLAG | VARCHAR2 | (1) | Indicates if Review is complete for this template. Defaulted to 'Y' if Wait for Review flag is set to ''N'. | |
FREEZE_FLAG | VARCHAR2 | (1) | Indicates if the worksheet is frozen(non-editable). | |
CREATE_INSTANCE_MEASURES_FLAG | VARCHAR2 | (1) | Indicates if instance measures have to be created. | |
DELETE_INSTANCE_MEASURES_FLAG | VARCHAR2 | (1) | Indicates if instance measures have to be deleted. | |
CREATE_APPROVAL_MEASURES_FLAG | VARCHAR2 | (1) | Indicates if approval measures have to be created. | |
DELETE_APPROVAL_MEASURES_FLAG | VARCHAR2 | (1) | Indicates if approval measures have to be deleted. | |
COPY_INSTANCE_DATA_FLAG | VARCHAR2 | (1) | Indicates if instance data should be copied from distributor's workspace to recipient's workspace on distribution. | |
COPY_TARGET_DATA_FLAG | VARCHAR2 | (1) | Indicates if target data should be copied from distributor's worksheet to recipient's worksheet on distribution. | |
APPROVER_TYPE | VARCHAR2 | (15) | Approver of the Worksheet -Manager of the recipient or the user who distributed the worksheet. Applicable only in a cascading distribution. | |
APPROVAL_DATE | DATE | The date the worksheet is approved. | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
BUSINESS_AREA_ID | NUMBER | Yes | Business Area Identifier. | |
CURRENCY_FLAG | VARCHAR2 | (1) | Indicates if currency conversion was selected for the Business Process. Value: Y/N | |
VIEW_TYPE | VARCHAR2 | (30) | Stores user's choice of data entry view. Value: BASE(BP currency)/ENTERED | |
MULTIPLE_SUBMISSIONS_FLAG | VARCHAR2 | (1) | Specifies if multiple submissions are allowed | |
PRIOR_LOCK_STATUS | VARCHAR2 | (30) | Stores the status of the worksheet prior to locking |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_ID
, TEMPLATE_ID
, ANALYSIS_CYCLE_ID
, AC_INSTANCE_ID
, AC_TEMPLATE_ID
, GENERATE_TEMPLATE_TASK_ID
, INSTRUCTION_TEXT_ID
, OBJECT_USER_ID
, DISTRIBUTOR_USER_ID
, APPROVER_USER_ID
, OBJECT_TYPE
, TEMPLATE_NAME
, USE_LAST_REVIEWED
, DESCRIPTION
, MULTIPLE_INPUT_LEVELS_FLAG
, DATAENTRY_OBJ_PATH
, DATAENTRY_OBJ_NAME
, ENABLE_TARGET_FLAG
, TARGET_OBJ_PATH
, TARGET_OBJ_NAME
, COPY_SOURCE_TYPE_FLAG
, CREATE_SOLVE_PROGRAM_FLAG
, PERSONAL_DATA_QUERY_FLAG
, PERSONAL_TARGET_QUERY_FLAG
, STATUS
, APPROVAL_REQUIRED_FLAG
, DEADLINE_DATE
, DISTRIBUTION_METHOD
, DISTRIBUTION_DIMENSION
, DISTRIBUTION_HIERARCHY
, DISTRIBUTION_DATE
, SUBMISSION_DATE
, SUBMITTED_BY
, WAIT_FOR_REVIEW_FLAG
, REVIEW_COMPLETE_FLAG
, FREEZE_FLAG
, CREATE_INSTANCE_MEASURES_FLAG
, DELETE_INSTANCE_MEASURES_FLAG
, CREATE_APPROVAL_MEASURES_FLAG
, DELETE_APPROVAL_MEASURES_FLAG
, COPY_INSTANCE_DATA_FLAG
, COPY_TARGET_DATA_FLAG
, APPROVER_TYPE
, APPROVAL_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, BUSINESS_AREA_ID
, CURRENCY_FLAG
, VIEW_TYPE
, MULTIPLE_SUBMISSIONS_FLAG
, PRIOR_LOCK_STATUS
FROM ZPB.ZPB_DC_OBJECTS;
ZPB.ZPB_DC_OBJECTS does not reference any database object
ZPB.ZPB_DC_OBJECTS is referenced by following:
|
|
|