[Home] [Help]
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
Name |
REPAIR_NUMBER |
INCIDENT_NUMBER |
INCIDENT_ID |
REFERENCE_NUMBER |
INVENTORY_ITEM_ID |
ITEM |
CUSTOMER_ID |
SERIAL_NUMBER |
CREATION_DATE |
DATE_CLOSED |
PROMISE_DATE |
STATUS |
REPAIR_LINE_ID |
QUANTITY |
UNIT_OF_MEASURE |
ACCOUNT_NUMBER |
ACCOUNT_NAME |