VIEW: APPS.CLN_PROCAT_PRICE_LISTS_V

Source

View Text - Preformatted

SELECT tl.name NAME, lh.list_header_id LIST_HEADER_ID, hca.party_id PARTY_ID, 'Y' ASSIGNED_FLAG from qp_list_headers_b lh, qp_list_headers_tl tl, qpbv_qualifiers qq, hz_cust_accounts hca WHERE tl.list_header_id = lh.list_header_id and qq.list_header_id = lh.list_header_id and qq.qualifier_attr_value = hca.cust_account_id and lh.list_type_code = 'PRL' and qq.qualifier_context = 'CUSTOMER' and qq.qualifier_attribute = 'QUALIFIER_ATTRIBUTE2' and TL.LANGUAGE = userenv('LANG') and ((nvl((select FND_PROFILE.VALUE('QP_SECURITY_CONTROL') from dual), 'OFF') = 'ON' AND (select FND_PROFILE.VALUE('ORG_ID') from dual) = LH.orig_org_id) OR (nvl((select FND_PROFILE.VALUE('QP_SECURITY_CONTROL') from dual), 'OFF') = 'ON' AND nvl(LH.global_flag,'Y') = 'Y') OR nvl((select FND_PROFILE.VALUE('QP_SECURITY_CONTROL') from dual), 'OFF') = 'OFF') union (select tl.name NAME, lh.list_header_id LIST_HEADER_ID, -1 PARTY_ID, 'N' ASSIGNED_FLAG from qp_list_headers_b lh, qp_list_headers_tl tl where tl.list_header_id = lh.list_header_id and lh.list_type_code = 'PRL' and TL.LANGUAGE = userenv('LANG') and ((nvl((select FND_PROFILE.VALUE('QP_SECURITY_CONTROL') from dual), 'OFF') = 'ON' AND (select FND_PROFILE.VALUE('ORG_ID') from dual) = LH.orig_org_id) OR (nvl((select FND_PROFILE.VALUE('QP_SECURITY_CONTROL') from dual), 'OFF') = 'ON' AND nvl(LH.global_flag,'Y') = 'Y') OR nvl((select FND_PROFILE.VALUE('QP_SECURITY_CONTROL') from dual), 'OFF') = 'OFF'))

View Text - HTML Formatted

SELECT TL.NAME NAME
, LH.LIST_HEADER_ID LIST_HEADER_ID
, HCA.PARTY_ID PARTY_ID
, 'Y' ASSIGNED_FLAG
FROM QP_LIST_HEADERS_B LH
, QP_LIST_HEADERS_TL TL
, QPBV_QUALIFIERS QQ
, HZ_CUST_ACCOUNTS HCA
WHERE TL.LIST_HEADER_ID = LH.LIST_HEADER_ID
AND QQ.LIST_HEADER_ID = LH.LIST_HEADER_ID
AND QQ.QUALIFIER_ATTR_VALUE = HCA.CUST_ACCOUNT_ID
AND LH.LIST_TYPE_CODE = 'PRL'
AND QQ.QUALIFIER_CONTEXT = 'CUSTOMER'
AND QQ.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE2'
AND TL.LANGUAGE = USERENV('LANG')
AND ((NVL((SELECT FND_PROFILE.VALUE('QP_SECURITY_CONTROL')
FROM DUAL)
, 'OFF') = 'ON'
AND (SELECT FND_PROFILE.VALUE('ORG_ID')
FROM DUAL) = LH.ORIG_ORG_ID) OR (NVL((SELECT FND_PROFILE.VALUE('QP_SECURITY_CONTROL')
FROM DUAL)
, 'OFF') = 'ON'
AND NVL(LH.GLOBAL_FLAG
, 'Y') = 'Y') OR NVL((SELECT FND_PROFILE.VALUE('QP_SECURITY_CONTROL')
FROM DUAL)
, 'OFF') = 'OFF') UNION (SELECT TL.NAME NAME
, LH.LIST_HEADER_ID LIST_HEADER_ID
, -1 PARTY_ID
, 'N' ASSIGNED_FLAG
FROM QP_LIST_HEADERS_B LH
, QP_LIST_HEADERS_TL TL
WHERE TL.LIST_HEADER_ID = LH.LIST_HEADER_ID
AND LH.LIST_TYPE_CODE = 'PRL'
AND TL.LANGUAGE = USERENV('LANG')
AND ((NVL((SELECT FND_PROFILE.VALUE('QP_SECURITY_CONTROL')
FROM DUAL)
, 'OFF') = 'ON'
AND (SELECT FND_PROFILE.VALUE('ORG_ID')
FROM DUAL) = LH.ORIG_ORG_ID) OR (NVL((SELECT FND_PROFILE.VALUE('QP_SECURITY_CONTROL')
FROM DUAL)
, 'OFF') = 'ON'
AND NVL(LH.GLOBAL_FLAG
, 'Y') = 'Y') OR NVL((SELECT FND_PROFILE.VALUE('QP_SECURITY_CONTROL')
FROM DUAL)
, 'OFF') = 'OFF'))