VIEW: APPS.QP_BLKTPRT_MOD_HEADER_V

Source

View Text - Preformatted

SELECT qlh.list_header_id, qlh.list_type_code, qlh.orig_system_header_ref header_id FROM qp_list_headers_b qlh WHERE qlh.list_source_code = 'BSO' AND qlh.list_type_code in ('DLT','SLT','CHARGES') AND nvl(qlh.active_flag, 'Y') = 'Y'

View Text - HTML Formatted

SELECT QLH.LIST_HEADER_ID
, QLH.LIST_TYPE_CODE
, QLH.ORIG_SYSTEM_HEADER_REF HEADER_ID
FROM QP_LIST_HEADERS_B QLH
WHERE QLH.LIST_SOURCE_CODE = 'BSO'
AND QLH.LIST_TYPE_CODE IN ('DLT'
, 'SLT'
, 'CHARGES')
AND NVL(QLH.ACTIVE_FLAG
, 'Y') = 'Y'