DBA Data[Home] [Help]

VIEW: APPS.CR_SQDS_TBL_V

Source

View Text - Preformatted

SELECT OPRN_NO , FROM_ITEM_CLASS , TO_ITEM_CLASS FROM CR_SQDS_TBL C, FM_OPRN_MST F WHERE C.OPRN_ID = F.OPRN_ID GROUP BY OPRN_NO, FROM_ITEM_CLASS, TO_ITEM_CLASS
View Text - HTML Formatted

SELECT OPRN_NO
, FROM_ITEM_CLASS
, TO_ITEM_CLASS
FROM CR_SQDS_TBL C
, FM_OPRN_MST F
WHERE C.OPRN_ID = F.OPRN_ID GROUP BY OPRN_NO
, FROM_ITEM_CLASS
, TO_ITEM_CLASS