View: CSD_RO_GROUP_JOBS_V

Product:	CSD - Depot Repair
Description:	View that fetches the details of the WIP job that is submitted for the repair order group.
Implementation/DBA Data:	APPS.CSD_RO_GROUP_JOBS_V

View Text

SELECT CRJX.ROWID
, CROG.REPAIR_GROUP_ID
, WE.WIP_ENTITY_NAME
, CRJX.GROUP_ID
, CRJX.ORGANIZATION_ID
, CRJX.QUANTITY
, CRJX.QUANTITY_COMPLETED
, WDJ.START_QUANTITY
, ML.MEANING STATUS
, MSI.CONCATENATED_SEGMENTS ROUTER
, HOU.NAME ORGANIZATION_NAME
FROM CSD_REPAIR_ORDER_GROUPS CROG
, CSD_REPAIRS CR
, CSD_REPAIR_JOB_XREF CRJX
, WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, MFG_LOOKUPS ML
, MTL_SYSTEM_ITEMS_KFV MSI
, HR_ORGANIZATION_UNITS HOU
WHERE CROG.REPAIR_GROUP_ID = CR.REPAIR_GROUP_ID
AND CR.REPAIR_LINE_ID = CRJX.REPAIR_LINE_ID
AND CRJX.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND CRJX.ORGANIZATION_ID = WE.ORGANIZATION_ID
AND CRJX.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND WDJ.STATUS_TYPE = ML.LOOKUP_CODE
AND ML.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND WDJ.ROUTING_REFERENCE_ID = MSI.INVENTORY_ITEM_ID(+)
AND WDJ.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)

Columns