VIEW: APPS.CZ_EXV_PRICE_LISTS

Source

View Text - Preformatted

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'