View: CSD_RO_SUMMARY_V

Product:	CSD - Depot Repair
Description:	Repair Order Summary View
Implementation/DBA Data:	APPS.CSD_RO_SUMMARY_V

View Text

SELECT DRA.REPAIR_NUMBER
, SR.INCIDENT_NUMBER
, SR.INCIDENT_ID
, DRTVL.NAME REPAIR_TYPE_NAME
, SR.STATUS SR_STATUS
, CP.INSTANCE_NUMBER REFERENCE_NUMBER
, DRA.INVENTORY_ITEM_ID
, ITEMS.CONCATENATED_SEGMENTS ITEM
, ITEMS.DESCRIPTION ITEM_DESC
, DRA.ITEM_REVISION ITEM_REVISION
, SR.CUSTOMER_ID
, DECODE(DRA.CUSTOMER_PRODUCT_ID
, ''
, DRA.SERIAL_NUMBER
, CP.SERIAL_NUMBER) SERIAL_NUMBER
, DRA.CREATION_DATE
, DRA.DATE_CLOSED
, DRA.PROMISE_DATE
, FNDL2.MEANING STATUS_MEANING
, DRA.REPAIR_LINE_ID
, DRA.QUANTITY
, UOM.UNIT_OF_MEASURE_TL
, SR.ACCOUNT_NUMBER
, DRA.REPAIR_TYPE_ID
, DRA.STATUS
, CP.LOCATION_ID INSTALL_SITE_USE_ID
, SR.ACCOUNT_NUMBER || '-' || SR.PARTY_NAME ACCOUNT_DETAIL
, SR.PARTY_NAME CUSTOMER_NAME
, SR.ACCOUNT_NUMBER CUSTOMER_ACCOUNT
, FNDL1.MEANING ESTIMATE_APPROVED
, DRA.FLOW_STATUS_ID
, CFB.FLOW_STATUS_CODE
, NVL(CFTL.EXTERNAL_DISPLAY_STATUS
, FND.MEANING) FLOW_STATUS_MEANING
FROM CSD_REPAIR_TYPES_VL DRTVL
, CSI_ITEM_INSTANCES CP
, MTL_SYSTEM_ITEMS_VL ITEMS
, MTL_UNITS_OF_MEASURE_VL UOM
, CSD_REPAIRS DRA
, FND_LOOKUPS FNDL1
, FND_LOOKUPS FNDL2
, CSD_INCIDENTS_NON_SEC_V SR
, CSD_FLOW_STATUSES_TL CFTL
, CSD_FLOW_STATUSES_B CFB
, FND_LOOKUPS FND
WHERE DRA.INCIDENT_ID = SR.INCIDENT_ID
AND DRA.REPAIR_TYPE_ID = DRTVL.REPAIR_TYPE_ID
AND DRA.CUSTOMER_PRODUCT_ID = CP.INSTANCE_ID(+)
AND DRA.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND ITEMS.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND DRA.UNIT_OF_MEASURE = UOM.UOM_CODE
AND DRA.APPROVAL_STATUS = FNDL1.LOOKUP_CODE (+)
AND FNDL1.LOOKUP_TYPE (+) = 'CSD_APPROVAL_STATUS'
AND DRA.STATUS = FNDL2.LOOKUP_CODE
AND FNDL2.LOOKUP_TYPE = 'CSD_REPAIR_STATUS'
AND CFB.STATUS_CODE = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'CSD_REPAIR_FLOW_STATUS'
AND DRA.FLOW_STATUS_ID = CFB.FLOW_STATUS_ID
AND CFB.FLOW_STATUS_ID = CFTL.FLOW_STATUS_ID
AND CFTL.LANGUAGE = USERENV('LANG')

Columns