VIEW: APPS.QPBV_PRICE_LISTS

Source

View Text - Preformatted

SELECT tl.NAME ,lh.ROUNDING_FACTOR ,lh.START_DATE_ACTIVE ,lh.END_DATE_ACTIVE ,lh.COMMENTS ,lh.ACTIVE_FLAG ,tl.DESCRIPTION ,lh.LIST_TYPE_CODE ,lh.CURRENCY_CODE ,lh.SOURCE_SYSTEM_CODE ,lh.SHIP_METHOD_CODE ,lh.FREIGHT_TERMS_CODE ,lh.LIST_HEADER_ID ,lh.TERMS_ID ,lh.CREATION_DATE ,lh.CREATED_BY ,lh.LAST_UPDATE_DATE ,lh.LAST_UPDATED_BY ,lh.ORIG_SYSTEM_HEADER_REF ,lh.PTE_CODE ,lh.LIST_SOURCE_CODE ,lh.ORIG_ORG_ID ,lh.GLOBAL_FLAG ,lh.SHAREABLE_FLAG ,lh.CURRENCY_HEADER_ID ,lh.SOLD_TO_ORG_ID ,lh.LOCKED_FROM_LIST_HEADER_ID 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','AGR')

View Text - HTML Formatted

SELECT TL.NAME
, LH.ROUNDING_FACTOR
, LH.START_DATE_ACTIVE
, LH.END_DATE_ACTIVE
, LH.COMMENTS
, LH.ACTIVE_FLAG
, TL.DESCRIPTION
, LH.LIST_TYPE_CODE
, LH.CURRENCY_CODE
, LH.SOURCE_SYSTEM_CODE
, LH.SHIP_METHOD_CODE
, LH.FREIGHT_TERMS_CODE
, LH.LIST_HEADER_ID
, LH.TERMS_ID
, LH.CREATION_DATE
, LH.CREATED_BY
, LH.LAST_UPDATE_DATE
, LH.LAST_UPDATED_BY
, LH.ORIG_SYSTEM_HEADER_REF
, LH.PTE_CODE
, LH.LIST_SOURCE_CODE
, LH.ORIG_ORG_ID
, LH.GLOBAL_FLAG
, LH.SHAREABLE_FLAG
, LH.CURRENCY_HEADER_ID
, LH.SOLD_TO_ORG_ID
, LH.LOCKED_FROM_LIST_HEADER_ID
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'
, 'AGR')