View: CSD_MASS_RO_SN_V

Product:	CSD - Depot Repair
Description:
Implementation/DBA Data:	APPS.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