VIEW: APPS.CLN_PROCAT_CATALOG_V

Source

View Text - Preformatted

SELECT tl.NAME ,lh.START_DATE_ACTIVE ,lh.END_DATE_ACTIVE ,lh.COMMENTS ,lh.ACTIVE_FLAG ,lh.LIST_TYPE_CODE , lh.LIST_HEADER_ID, 0 CURRENCY_DETAIL_ID, lh.currency_code to_currency_code, 1 fixed_value from qp_list_headers_b lh, qp_list_headers_tl tl WHERE lh.list_header_id = tl.list_header_id and tl.language = userenv('lang') and lh.list_type_code in ('PRL') and lh.active_flag = 'Y' UNION (SELECT tl.NAME ,lh.START_DATE_ACTIVE ,lh.END_DATE_ACTIVE ,lh.COMMENTS ,lh.ACTIVE_FLAG ,lh.LIST_TYPE_CODE , lh.LIST_HEADER_ID, qcd.CURRENCY_DETAIL_ID, qcd.to_currency_code, qcd.fixed_value from qp_list_headers_b lh, qp_list_headers_tl tl, qp_currency_details qcd WHERE lh.list_header_id = tl.list_header_id and tl.language = userenv('lang') and lh.list_type_code in ('PRL') and lh.active_flag = 'Y' and lh.currency_header_id = qcd.currency_header_id)

View Text - HTML Formatted

SELECT TL.NAME
, LH.START_DATE_ACTIVE
, LH.END_DATE_ACTIVE
, LH.COMMENTS
, LH.ACTIVE_FLAG
, LH.LIST_TYPE_CODE
, LH.LIST_HEADER_ID
, 0 CURRENCY_DETAIL_ID
, LH.CURRENCY_CODE TO_CURRENCY_CODE
, 1 FIXED_VALUE
FROM QP_LIST_HEADERS_B LH
, QP_LIST_HEADERS_TL TL
WHERE LH.LIST_HEADER_ID = TL.LIST_HEADER_ID
AND TL.LANGUAGE = USERENV('LANG')
AND LH.LIST_TYPE_CODE IN ('PRL')
AND LH.ACTIVE_FLAG = 'Y' UNION (SELECT TL.NAME
, LH.START_DATE_ACTIVE
, LH.END_DATE_ACTIVE
, LH.COMMENTS
, LH.ACTIVE_FLAG
, LH.LIST_TYPE_CODE
, LH.LIST_HEADER_ID
, QCD.CURRENCY_DETAIL_ID
, QCD.TO_CURRENCY_CODE
, QCD.FIXED_VALUE
FROM QP_LIST_HEADERS_B LH
, QP_LIST_HEADERS_TL TL
, QP_CURRENCY_DETAILS QCD
WHERE LH.LIST_HEADER_ID = TL.LIST_HEADER_ID
AND TL.LANGUAGE = USERENV('LANG')
AND LH.LIST_TYPE_CODE IN ('PRL')
AND LH.ACTIVE_FLAG = 'Y'
AND LH.CURRENCY_HEADER_ID = QCD.CURRENCY_HEADER_ID)