eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: ZPB.ZPB_DC_OBJECTS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

ZPB.ZPB_DC_OBJECTS does not reference any database object

ZPB.ZPB_DC_OBJECTS is referenced by following:

APPS: ZPB_DC_OBJECTS