[Home] [Help]
View: CSD_MASS_RO_SN_V
View Text
SELECT A.MASS_RO_SN_ID
, A.SERIAL_NUMBER
, A.REPAIR_LINE_ID
, C.REPAIR_NUMBER
, A.INSTANCE_ID
, B.INSTANCE_NUMBER
, A.OBJECT_VERSION_NUMBER
FROM CSD_MASS_RO_SN A
, CSI_ITEM_INSTANCES B
, CSD_REPAIRS C
WHERE A.INSTANCE_ID = B.INSTANCE_ID (+)
AND A.REPAIR_LINE_ID = C.REPAIR_LINE_ID
Columns
Name |
MASS_RO_SN_ID |
SERIAL_NUMBER |
REPAIR_LINE_ID |
REPAIR_NUMBER |
INSTANCE_ID |
INSTANCE_NUMBER |
OBJECT_VERSION_NUMBER |