SELECT /*+DRIVING_SITE(SO_PRICE_LISTS) ORDERED */
L.NAME,L.DESCRIPTION,L.CURRENCY_CODE,L.PRICE_LIST_ID
FROM CZ_XFR_PRICE_LISTS P,SO_PRICE_LISTS L
WHERE P.PRICE_LIST_ID=L.PRICE_LIST_ID
AND P.DELETED_FLAG='0'
View Text - HTML Formatted
SELECT /*+DRIVING_SITE(SO_PRICE_LISTS) ORDERED */
L.NAME , L.DESCRIPTION , L.CURRENCY_CODE , L.PRICE_LIST_ID
FROM CZ_XFR_PRICE_LISTS P , SO_PRICE_LISTS L
WHERE P.PRICE_LIST_ID=L.PRICE_LIST_ID
AND P.DELETED_FLAG='0'