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]

VIEW: APPS.CST_XLA_DISCRETE_JOB_REF_V

Object Details

Object Name:	CST_XLA_DISCRETE_JOB_REF_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_XLA_DISCRETE_JOB_REF_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DIS_JOB_WIP_ENTITY_ID	NUMBER		Yes	WIP Job Identifier
DIS_JOB_SOURCE_CODE	VARCHAR2	(30)		Code of the process that generated the job record(null if created by Oracle Work In Process)
DIS_JOB_DESCRIPTION	VARCHAR2	(240)		Descriptive text
DIS_JOB_STATUS_TYPE	NUMBER		Yes	Status of job
DIS_JOB_DEMAND_CLASS	VARCHAR2	(30)		Type of demand the job satisfies
DIS_JOB_TYPE	NUMBER		Yes	Type of discrete job
DIS_JOB_SUPPLY_TYPE	NUMBER		Yes	Method of material consumption within WIP
DIS_JOB_ISSUE_ZERO_COST	VARCHAR2	(1)
DIS_JOB_SCHED_START_DATE	DATE		Yes
DIS_JOB_SCHED_COMP_DATE	DATE		Yes
DIS_JOB_RELEASE_DATE	DATE
DIS_JOB_COMP_DATE	DATE
DIS_JOB_CLOSE_DATE	DATE
DIS_JOB_DUE_DATE	DATE
DIS_JOB_PRIORITY	NUMBER
DIS_JOB_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
DIS_JOB_ATTRIBUTE1	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE2	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE3	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE4	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE5	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE6	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE7	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE8	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE9	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE10	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE11	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE12	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE13	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE14	VARCHAR2	(150)
DIS_JOB_ATTRIBUTE15	VARCHAR2	(150)
DIS_JOB_BOM_REVISION	VARCHAR2	(3)
DIS_JOB_ROUTING_REVISION	VARCHAR2	(3)
DIS_JOB_ACCT_CLASS	VARCHAR2	(10)	Yes
DIS_JOB_ACCT_CLASS_TYPE	NUMBER		Yes
DIS_JOB_ACCT_CLASS_DESCRIPTION	VARCHAR2	(240)
DIS_JOB_COMPLETION_COST_SOURCE	NUMBER
DIS_JOB_COMP_COST_TYPE_ID	NUMBER
DIS_JOB_COMPLETION_COST_TYPE	VARCHAR2	(10)
DIS_JOB_SYSTEM_OPTION_ID	NUMBER
DIS_JOB_ACCT_CLASS_ATTR_CAT	VARCHAR2	(30)
DIS_JOB_ACCT_CLASS_ATTRIBUTE1	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE2	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE3	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE4	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE5	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE6	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE7	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE8	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE9	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE10	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE11	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE12	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE13	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE14	VARCHAR2	(150)
DIS_JOB_ACCT_CLASS_ATTRIBUTE15	VARCHAR2	(150)
DIS_JOB_PARENT_WIP_ENTITY_ID	NUMBER
DIS_JOB_PARENT_WIP_ENTITY	VARCHAR2	(240)
DIS_JOB_ASSET_NUMBER	VARCHAR2	(30)
DIS_JOB_ASSET_GROUP_ID	NUMBER
DIS_JOB_REBUILD_ITEM_ID	NUMBER
DIS_JOB_REBUILD_SERIAL_NUMBER	VARCHAR2	(30)
DIS_JOB_WORK_ORDER_TYPE	VARCHAR2	(30)
DIS_JOB_OWNING_DEPARTMENT	NUMBER
DIS_JOB_OWN_DEPT_MAINT_CST_CAT	VARCHAR2	(30)
DIS_JOB_ACTIVITY_TYPE	VARCHAR2	(30)
DIS_JOB_ACTIVITY_CAUSE	VARCHAR2	(30)
DIS_JOB_ACTIVITY_SOURCE	VARCHAR2	(30)
DIS_JOB_PLANNED_MAINTENANCE	VARCHAR2	(1)
DIS_JOB_MAINT_OBJECT_ID	NUMBER
DIS_JOB_MAINT_OBJECT_TYPE	NUMBER
DIS_JOB_MAINT_OBJECT_SOURCE	NUMBER
DIS_JOB_EAM_LINEAR_LOCATION_ID	NUMBER
DIS_JOB_BRIDGING_ACCT	NUMBER
DIS_JOB_MATERIAL_ACCT	NUMBER
DIS_JOB_MAT_OVH_ACCT	NUMBER
DIS_JOB_OUT_PROC_ACCT	NUMBER
DIS_JOB_OVERHEAD_ACCT	NUMBER
DIS_JOB_RESOURCE_ACCT	NUMBER
DIS_JOB_EXPENSE_ACCT	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DIS_JOB_WIP_ENTITY_ID
,      DIS_JOB_SOURCE_CODE
,      DIS_JOB_DESCRIPTION
,      DIS_JOB_STATUS_TYPE
,      DIS_JOB_DEMAND_CLASS
,      DIS_JOB_TYPE
,      DIS_JOB_SUPPLY_TYPE
,      DIS_JOB_ISSUE_ZERO_COST
,      DIS_JOB_SCHED_START_DATE
,      DIS_JOB_SCHED_COMP_DATE
,      DIS_JOB_RELEASE_DATE
,      DIS_JOB_COMP_DATE
,      DIS_JOB_CLOSE_DATE
,      DIS_JOB_DUE_DATE
,      DIS_JOB_PRIORITY
,      DIS_JOB_ATTRIBUTE_CATEGORY
,      DIS_JOB_ATTRIBUTE1
,      DIS_JOB_ATTRIBUTE2
,      DIS_JOB_ATTRIBUTE3
,      DIS_JOB_ATTRIBUTE4
,      DIS_JOB_ATTRIBUTE5
,      DIS_JOB_ATTRIBUTE6
,      DIS_JOB_ATTRIBUTE7
,      DIS_JOB_ATTRIBUTE8
,      DIS_JOB_ATTRIBUTE9
,      DIS_JOB_ATTRIBUTE10
,      DIS_JOB_ATTRIBUTE11
,      DIS_JOB_ATTRIBUTE12
,      DIS_JOB_ATTRIBUTE13
,      DIS_JOB_ATTRIBUTE14
,      DIS_JOB_ATTRIBUTE15
,      DIS_JOB_BOM_REVISION
,      DIS_JOB_ROUTING_REVISION
,      DIS_JOB_ACCT_CLASS
,      DIS_JOB_ACCT_CLASS_TYPE
,      DIS_JOB_ACCT_CLASS_DESCRIPTION
,      DIS_JOB_COMPLETION_COST_SOURCE
,      DIS_JOB_COMP_COST_TYPE_ID
,      DIS_JOB_COMPLETION_COST_TYPE
,      DIS_JOB_SYSTEM_OPTION_ID
,      DIS_JOB_ACCT_CLASS_ATTR_CAT
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE1
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE2
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE3
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE4
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE5
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE6
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE7
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE8
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE9
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE10
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE11
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE12
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE13
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE14
,      DIS_JOB_ACCT_CLASS_ATTRIBUTE15
,      DIS_JOB_PARENT_WIP_ENTITY_ID
,      DIS_JOB_PARENT_WIP_ENTITY
,      DIS_JOB_ASSET_NUMBER
,      DIS_JOB_ASSET_GROUP_ID
,      DIS_JOB_REBUILD_ITEM_ID
,      DIS_JOB_REBUILD_SERIAL_NUMBER
,      DIS_JOB_WORK_ORDER_TYPE
,      DIS_JOB_OWNING_DEPARTMENT
,      DIS_JOB_OWN_DEPT_MAINT_CST_CAT
,      DIS_JOB_ACTIVITY_TYPE
,      DIS_JOB_ACTIVITY_CAUSE
,      DIS_JOB_ACTIVITY_SOURCE
,      DIS_JOB_PLANNED_MAINTENANCE
,      DIS_JOB_MAINT_OBJECT_ID
,      DIS_JOB_MAINT_OBJECT_TYPE
,      DIS_JOB_MAINT_OBJECT_SOURCE
,      DIS_JOB_EAM_LINEAR_LOCATION_ID
,      DIS_JOB_BRIDGING_ACCT
,      DIS_JOB_MATERIAL_ACCT
,      DIS_JOB_MAT_OVH_ACCT
,      DIS_JOB_OUT_PROC_ACCT
,      DIS_JOB_OVERHEAD_ACCT
,      DIS_JOB_RESOURCE_ACCT
,      DIS_JOB_EXPENSE_ACCT
FROM APPS.CST_XLA_DISCRETE_JOB_REF_V;

Dependencies

[top of page]

APPS.CST_XLA_DISCRETE_JOB_REF_V references the following:

APPS: BOM_DEPARTMENTS; CST_COST_TYPES; WIP_ACCOUNTING_CLASSES; WIP_DISCRETE_JOBS; WIP_ENTITIES

APPS.CST_XLA_DISCRETE_JOB_REF_V is referenced by following:

APPS: XLA_00707_AAD_S_000019_PKG - show dependent code; XLA_00707_AAD_S_000020_PKG - show dependent code