View: CST_XLA_DISCRETE_JOB_REF_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_XLA_DISCRETE_JOB_REF_V

View Text

SELECT WDJ.WIP_ENTITY_ID DIS_JOB_WIP_ENTITY_ID
, WDJ.SOURCE_CODE DIS_JOB_SOURCE_CODE
, WDJ.DESCRIPTION DIS_JOB_DESCRIPTION
, WDJ.STATUS_TYPE DIS_JOB_STATUS_TYPE
, WDJ.DEMAND_CLASS DIS_JOB_DEMAND_CLASS
, WDJ.JOB_TYPE DIS_JOB_TYPE
, WDJ.WIP_SUPPLY_TYPE DIS_JOB_SUPPLY_TYPE
, NVL(WDJ.ISSUE_ZERO_COST_FLAG
, 'N') DIS_JOB_ISSUE_ZERO_COST
, WDJ.SCHEDULED_START_DATE DIS_JOB_SCHED_START_DATE
, WDJ.SCHEDULED_COMPLETION_DATE DIS_JOB_SCHED_COMP_DATE
, WDJ.DATE_RELEASED DIS_JOB_RELEASE_DATE
, WDJ.DATE_COMPLETED DIS_JOB_COMP_DATE
, WDJ.DATE_CLOSED DIS_JOB_CLOSE_DATE
, WDJ.DUE_DATE DIS_JOB_DUE_DATE
, WDJ.PRIORITY DIS_JOB_PRIORITY
, WDJ.ATTRIBUTE_CATEGORY DIS_JOB_ATTRIBUTE_CATEGORY
, WDJ.ATTRIBUTE1 DIS_JOB_ATTRIBUTE1
, WDJ.ATTRIBUTE2 DIS_JOB_ATTRIBUTE2
, WDJ.ATTRIBUTE3 DIS_JOB_ATTRIBUTE3
, WDJ.ATTRIBUTE4 DIS_JOB_ATTRIBUTE4
, WDJ.ATTRIBUTE5 DIS_JOB_ATTRIBUTE5
, WDJ.ATTRIBUTE6 DIS_JOB_ATTRIBUTE6
, WDJ.ATTRIBUTE7 DIS_JOB_ATTRIBUTE7
, WDJ.ATTRIBUTE8 DIS_JOB_ATTRIBUTE8
, WDJ.ATTRIBUTE9 DIS_JOB_ATTRIBUTE9
, WDJ.ATTRIBUTE10 DIS_JOB_ATTRIBUTE10
, WDJ.ATTRIBUTE11 DIS_JOB_ATTRIBUTE11
, WDJ.ATTRIBUTE12 DIS_JOB_ATTRIBUTE12
, WDJ.ATTRIBUTE13 DIS_JOB_ATTRIBUTE13
, WDJ.ATTRIBUTE14 DIS_JOB_ATTRIBUTE14
, WDJ.ATTRIBUTE15 DIS_JOB_ATTRIBUTE15
, WDJ.BOM_REVISION DIS_JOB_BOM_REVISION
, WDJ.ROUTING_REVISION DIS_JOB_ROUTING_REVISION
, WDJ.CLASS_CODE DIS_JOB_ACCT_CLASS
, WAC.CLASS_TYPE DIS_JOB_ACCT_CLASS_TYPE
, WAC.DESCRIPTION DIS_JOB_ACCT_CLASS_DESCRIPTION
, WAC.COMPLETION_COST_SOURCE DIS_JOB_COMPLETION_COST_SOURCE
, WAC.COST_TYPE_ID DIS_JOB_COMP_COST_TYPE_ID
, CCT.COST_TYPE DIS_JOB_COMPLETION_COST_TYPE
, WAC.SYSTEM_OPTION_ID DIS_JOB_SYSTEM_OPTION_ID
, WAC.ATTRIBUTE_CATEGORY DIS_JOB_ACCT_CLASS_ATTR_CAT
, WAC.ATTRIBUTE1 DIS_JOB_ACCT_CLASS_ATTRIBUTE1
, WAC.ATTRIBUTE2 DIS_JOB_ACCT_CLASS_ATTRIBUTE2
, WAC.ATTRIBUTE3 DIS_JOB_ACCT_CLASS_ATTRIBUTE3
, WAC.ATTRIBUTE4 DIS_JOB_ACCT_CLASS_ATTRIBUTE4
, WAC.ATTRIBUTE5 DIS_JOB_ACCT_CLASS_ATTRIBUTE5
, WAC.ATTRIBUTE6 DIS_JOB_ACCT_CLASS_ATTRIBUTE6
, WAC.ATTRIBUTE7 DIS_JOB_ACCT_CLASS_ATTRIBUTE7
, WAC.ATTRIBUTE8 DIS_JOB_ACCT_CLASS_ATTRIBUTE8
, WAC.ATTRIBUTE9 DIS_JOB_ACCT_CLASS_ATTRIBUTE9
, WAC.ATTRIBUTE10 DIS_JOB_ACCT_CLASS_ATTRIBUTE10
, WAC.ATTRIBUTE11 DIS_JOB_ACCT_CLASS_ATTRIBUTE11
, WAC.ATTRIBUTE12 DIS_JOB_ACCT_CLASS_ATTRIBUTE12
, WAC.ATTRIBUTE13 DIS_JOB_ACCT_CLASS_ATTRIBUTE13
, WAC.ATTRIBUTE14 DIS_JOB_ACCT_CLASS_ATTRIBUTE14
, WAC.ATTRIBUTE15 DIS_JOB_ACCT_CLASS_ATTRIBUTE15
, WDJ.PARENT_WIP_ENTITY_ID DIS_JOB_PARENT_WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME DIS_JOB_PARENT_WIP_ENTITY
, WDJ.ASSET_NUMBER DIS_JOB_ASSET_NUMBER
, WDJ.ASSET_GROUP_ID DIS_JOB_ASSET_GROUP_ID
, WDJ.REBUILD_ITEM_ID DIS_JOB_REBUILD_ITEM_ID
, WDJ.REBUILD_SERIAL_NUMBER DIS_JOB_REBUILD_SERIAL_NUMBER
, WDJ.WORK_ORDER_TYPE DIS_JOB_WORK_ORDER_TYPE
, WDJ.OWNING_DEPARTMENT DIS_JOB_OWNING_DEPARTMENT
, BD.MAINT_COST_CATEGORY DIS_JOB_OWN_DEPT_MAINT_CST_CAT
, WDJ.ACTIVITY_TYPE DIS_JOB_ACTIVITY_TYPE
, WDJ.ACTIVITY_CAUSE DIS_JOB_ACTIVITY_CAUSE
, WDJ.ACTIVITY_SOURCE DIS_JOB_ACTIVITY_SOURCE
, WDJ.PLAN_MAINTENANCE DIS_JOB_PLANNED_MAINTENANCE
, WDJ.MAINTENANCE_OBJECT_ID DIS_JOB_MAINT_OBJECT_ID
, WDJ.MAINTENANCE_OBJECT_TYPE DIS_JOB_MAINT_OBJECT_TYPE
, WDJ.MAINTENANCE_OBJECT_SOURCE DIS_JOB_MAINT_OBJECT_SOURCE
, WDJ.EAM_LINEAR_LOCATION_ID DIS_JOB_EAM_LINEAR_LOCATION_ID
, WAC.BRIDGING_ACCOUNT DIS_JOB_BRIDGING_ACCT
, WDJ.MATERIAL_ACCOUNT DIS_JOB_MATERIAL_ACCT
, WDJ.MATERIAL_OVERHEAD_ACCOUNT DIS_JOB_MAT_OVHD_ACCT
, WDJ.OUTSIDE_PROCESSING_ACCOUNT DIS_JOB_OUT_PROC_ACCT
, WDJ.OVERHEAD_ACCOUNT DIS_JOB_OVERHEAD_ACCT
, WDJ.RESOURCE_ACCOUNT DIS_JOB_RESOURCE_ACCT
, WAC.EXPENSE_ACCOUNT DIS_JOB_EXPENSE_ACCT
FROM WIP_DISCRETE_JOBS WDJ
, WIP_ACCOUNTING_CLASSES WAC
, CST_COST_TYPES CCT
, WIP_ENTITIES WE
, BOM_DEPARTMENTS BD
WHERE WDJ.CLASS_CODE = WAC.CLASS_CODE
AND WDJ.ORGANIZATION_ID = WAC.ORGANIZATION_ID
AND WAC.COST_TYPE_ID = CCT.COST_TYPE_ID (+)
AND WE.WIP_ENTITY_ID (+) = WDJ.PARENT_WIP_ENTITY_ID
AND BD.DEPARTMENT_ID (+) = WDJ.OWNING_DEPARTMENT

Columns