VIEW: APPS.QP_BLKTPRT_PRL_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 = 'PRL' 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 = 'PRL'
AND NVL(QLH.ACTIVE_FLAG
, 'Y') = 'Y'