View: CSD_RO_V

Product:	CSD - Depot Repair
Description:
Implementation/DBA Data:	APPS.CSD_RO_V

View Text

SELECT REPAIR_NUMBER
, INCIDENT_NUMBER
, INCIDENT_ID
, REFERENCE_NUMBER
, INVENTORY_ITEM_ID
, ITEM
, CUSTOMER_ID
, SERIAL_NUMBER
, CSD.CREATION_DATE
, DATE_CLOSED
, PROMISE_DATE
, CSD.STATUS
, REPAIR_LINE_ID
, QUANTITY
, UNIT_OF_MEASURE
, HZ.ACCOUNT_NUMBER
, HZ.ACCOUNT_NAME
FROM CSD_REPAIRS_V CSD
, HZ_CUST_ACCOUNTS HZ
WHERE CSD.CUSTOMER_ID= HZ.CUST_ACCOUNT_ID

Columns