View: CSD_REPAIR_JOB_XREF_V

Product:	CSD - Depot Repair
Description:	The view for getting repair order jobs.
Implementation/DBA Data:	APPS.CSD_REPAIR_JOB_XREF_V

View Text

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'

Columns