VIEW: APPS.CST_XLA_DISCRETE_JOB_REF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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