VIEW: APPS.CSD_REPAIR_JOB_XREF_V

Source

View Text - Preformatted

SELECT drj.rowid, drj.repair_job_xref_id, drj.created_by, drj.creation_date, drj.last_updated_by, drj.last_update_date, drj.last_update_login, drj.repair_line_id, drj.wip_entity_id, entity.wip_entity_name, drj.group_id, jobs.organization_id, hou.name organization_name, decode ( drj.quantity, jobs.start_quantity, NULL, drj.quantity ) allocated_created_quantity , decode( drj.quantity, jobs.start_quantity, NULL, nvl(drj.quantity_completed, 0) ) allocated_completed_quantity , jobs.start_quantity created_quantity, jobs.quantity_completed completed_quantity, jobs.status_type, lookups.meaning status_meaning, jobs.routing_reference_id, items.concatenated_segments routing_reference, jobs.alternate_routing_designator, drj.attribute_category, drj.attribute1, drj.attribute2, drj.attribute3, drj.attribute4, drj.attribute5, drj.attribute6, drj.attribute7, drj.attribute8, drj.attribute9, drj.attribute10, drj.attribute11, drj.attribute12, drj.attribute13, drj.attribute14, drj.attribute15, drj.inventory_item_id, msidj.concatenated_segments product, drj.object_version_number, drj.Source_type_code, drjlk.Meaning Source_type, drj.source_id1 source_id1, csc.name source_name, drj.ro_service_code_id from wip_discrete_jobs jobs, wip_entities entity, hr_organization_units hou, mfg_lookups lookups, mtl_system_items_kfv items, csd_repair_job_xref drj, fnd_lookups drjlk, mtl_system_items_kfv msidj, csd_service_codes_vl csc WHERE drj.wip_entity_id = entity.wip_entity_id and drj.wip_entity_id = jobs.wip_entity_id and drj.organization_id = hou.organization_id and jobs.status_type = lookups.lookup_code and lookups.lookup_type = 'WIP_JOB_STATUS' and jobs.routing_reference_id = items.inventory_item_id(+) and jobs.organization_id = items.organization_id(+) and drj.inventory_item_id = msidj.inventory_item_id and drj.organization_id = msidj.organization_id and drj.source_id1 = csc.service_code_id (+) and drj.source_type_code = drjlk.lookup_code(+) and drjlk.lookup_type(+) = 'CSD_SOURCE_TYPE'

View Text - HTML Formatted

SELECT DRJ.ROWID
, DRJ.REPAIR_JOB_XREF_ID
, DRJ.CREATED_BY
, DRJ.CREATION_DATE
, DRJ.LAST_UPDATED_BY
, DRJ.LAST_UPDATE_DATE
, DRJ.LAST_UPDATE_LOGIN
, DRJ.REPAIR_LINE_ID
, DRJ.WIP_ENTITY_ID
, ENTITY.WIP_ENTITY_NAME
, DRJ.GROUP_ID
, JOBS.ORGANIZATION_ID
, HOU.NAME ORGANIZATION_NAME
, DECODE ( DRJ.QUANTITY
, JOBS.START_QUANTITY
, NULL
, DRJ.QUANTITY ) ALLOCATED_CREATED_QUANTITY
, DECODE( DRJ.QUANTITY
, JOBS.START_QUANTITY
, NULL
, NVL(DRJ.QUANTITY_COMPLETED
, 0) ) ALLOCATED_COMPLETED_QUANTITY
, JOBS.START_QUANTITY CREATED_QUANTITY
, JOBS.QUANTITY_COMPLETED COMPLETED_QUANTITY
, JOBS.STATUS_TYPE
, LOOKUPS.MEANING STATUS_MEANING
, JOBS.ROUTING_REFERENCE_ID
, ITEMS.CONCATENATED_SEGMENTS ROUTING_REFERENCE
, JOBS.ALTERNATE_ROUTING_DESIGNATOR
, DRJ.ATTRIBUTE_CATEGORY
, DRJ.ATTRIBUTE1
, DRJ.ATTRIBUTE2
, DRJ.ATTRIBUTE3
, DRJ.ATTRIBUTE4
, DRJ.ATTRIBUTE5
, DRJ.ATTRIBUTE6
, DRJ.ATTRIBUTE7
, DRJ.ATTRIBUTE8
, DRJ.ATTRIBUTE9
, DRJ.ATTRIBUTE10
, DRJ.ATTRIBUTE11
, DRJ.ATTRIBUTE12
, DRJ.ATTRIBUTE13
, DRJ.ATTRIBUTE14
, DRJ.ATTRIBUTE15
, DRJ.INVENTORY_ITEM_ID
, MSIDJ.CONCATENATED_SEGMENTS PRODUCT
, DRJ.OBJECT_VERSION_NUMBER
, DRJ.SOURCE_TYPE_CODE
, DRJLK.MEANING SOURCE_TYPE
, DRJ.SOURCE_ID1 SOURCE_ID1
, CSC.NAME SOURCE_NAME
, DRJ.RO_SERVICE_CODE_ID
FROM WIP_DISCRETE_JOBS JOBS
, WIP_ENTITIES ENTITY
, HR_ORGANIZATION_UNITS HOU
, MFG_LOOKUPS LOOKUPS
, MTL_SYSTEM_ITEMS_KFV ITEMS
, CSD_REPAIR_JOB_XREF DRJ
, FND_LOOKUPS DRJLK
, MTL_SYSTEM_ITEMS_KFV MSIDJ
, CSD_SERVICE_CODES_VL CSC
WHERE DRJ.WIP_ENTITY_ID = ENTITY.WIP_ENTITY_ID
AND DRJ.WIP_ENTITY_ID = JOBS.WIP_ENTITY_ID
AND DRJ.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND JOBS.STATUS_TYPE = LOOKUPS.LOOKUP_CODE
AND LOOKUPS.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND JOBS.ROUTING_REFERENCE_ID = ITEMS.INVENTORY_ITEM_ID(+)
AND JOBS.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID(+)
AND DRJ.INVENTORY_ITEM_ID = MSIDJ.INVENTORY_ITEM_ID
AND DRJ.ORGANIZATION_ID = MSIDJ.ORGANIZATION_ID
AND DRJ.SOURCE_ID1 = CSC.SERVICE_CODE_ID (+)
AND DRJ.SOURCE_TYPE_CODE = DRJLK.LOOKUP_CODE(+)
AND DRJLK.LOOKUP_TYPE(+) = 'CSD_SOURCE_TYPE'