VIEW: APPS.QPFV_PROMOTION_HEADERS

Source

View Text - Preformatted

SELECT tl.NAME ,tl.DESCRIPTION ,lh.AUTOMATIC_FLAG ,lh.START_DATE_ACTIVE ,lh.END_DATE_ACTIVE ,lh.COMMENTS ,lh.ACTIVE_FLAG ,tl.VERSION_NO ,lh.ASK_FOR_FLAG ,lh.PARENT_LIST_HEADER_ID ,lh.START_DATE_ACTIVE_FIRST ,lh.END_DATE_ACTIVE_FIRST ,lh.START_DATE_ACTIVE_SECOND ,lh.END_DATE_ACTIVE_SECOND ,lh.CURRENCY_CODE ,cur.NAME ,lh.LIST_TYPE_CODE ,'_LA:lh.LIST_TYPE_CODE:QP_LOOKUPS:LIST_TYPE_CODE:MEANING' ,lh.SOURCE_SYSTEM_CODE ,'_LA:lh.SOURCE_SYSTEM_CODE:QP_LOOKUPS:SOURCE_SYSTEM:MEANING' ,lh.ACTIVE_DATE_FIRST_TYPE ,'_LA:lh.ACTIVE_DATE_FIRST_TYPE:QP_LOOKUPS:EFFECTIVE_DATE_TYPES:MEANING' ,lh.ACTIVE_DATE_SECOND_TYPE ,'_LA:lh.ACTIVE_DATE_SECOND_TYPE:QP_LOOKUPS:EFFECTIVE_DATE_TYPES:MEANING' ,lh.LIST_HEADER_ID ,lh.CREATION_DATE ,lh.CREATED_BY ,lh.LAST_UPDATE_DATE ,lh.LAST_UPDATED_BY , '_DF:QP:QP_LIST_HEADERS:lh' ,lh.PTE_CODE ,'_LA:lh.PTE_CODE:QP_LOOKUPS:QP_PTE_TYPE:MEANING' ,lh.LIST_SOURCE_CODE ,lh.ORIG_SYSTEM_HEADER_REF ,lh.ORIG_ORG_ID ,lh.GLOBAL_FLAG ,lh.SHAREABLE_FLAG FROM qp_list_headers_b lh, qp_list_headers_tl tl, fnd_currencies_vl cur WHERE lh.list_header_id = tl.list_header_id and lh.list_type_code in ('DEL','PRO') and tl.language = userenv('lang') and lh.currency_code = cur.currency_code (+) WITH READ ONLY

View Text - HTML Formatted

SELECT TL.NAME
, TL.DESCRIPTION
, LH.AUTOMATIC_FLAG
, LH.START_DATE_ACTIVE
, LH.END_DATE_ACTIVE
, LH.COMMENTS
, LH.ACTIVE_FLAG
, TL.VERSION_NO
, LH.ASK_FOR_FLAG
, LH.PARENT_LIST_HEADER_ID
, LH.START_DATE_ACTIVE_FIRST
, LH.END_DATE_ACTIVE_FIRST
, LH.START_DATE_ACTIVE_SECOND
, LH.END_DATE_ACTIVE_SECOND
, LH.CURRENCY_CODE
, CUR.NAME
, LH.LIST_TYPE_CODE
, '_LA:LH.LIST_TYPE_CODE:QP_LOOKUPS:LIST_TYPE_CODE:MEANING'
, LH.SOURCE_SYSTEM_CODE
, '_LA:LH.SOURCE_SYSTEM_CODE:QP_LOOKUPS:SOURCE_SYSTEM:MEANING'
, LH.ACTIVE_DATE_FIRST_TYPE
, '_LA:LH.ACTIVE_DATE_FIRST_TYPE:QP_LOOKUPS:EFFECTIVE_DATE_TYPES:MEANING'
, LH.ACTIVE_DATE_SECOND_TYPE
, '_LA:LH.ACTIVE_DATE_SECOND_TYPE:QP_LOOKUPS:EFFECTIVE_DATE_TYPES:MEANING'
, LH.LIST_HEADER_ID
, LH.CREATION_DATE
, LH.CREATED_BY
, LH.LAST_UPDATE_DATE
, LH.LAST_UPDATED_BY
, '_DF:QP:QP_LIST_HEADERS:LH'
, LH.PTE_CODE
, '_LA:LH.PTE_CODE:QP_LOOKUPS:QP_PTE_TYPE:MEANING'
, LH.LIST_SOURCE_CODE
, LH.ORIG_SYSTEM_HEADER_REF
, LH.ORIG_ORG_ID
, LH.GLOBAL_FLAG
, LH.SHAREABLE_FLAG
FROM QP_LIST_HEADERS_B LH
, QP_LIST_HEADERS_TL TL
, FND_CURRENCIES_VL CUR
WHERE LH.LIST_HEADER_ID = TL.LIST_HEADER_ID
AND LH.LIST_TYPE_CODE IN ('DEL'
, 'PRO')
AND TL.LANGUAGE = USERENV('LANG')
AND LH.CURRENCY_CODE = CUR.CURRENCY_CODE (+) WITH READ ONLY