VIEW: APPS.CSD_MASS_RO_SN_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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