eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.QP_PRICELISTS_LOV_V

Source

View Text - Preformatted


SELECT qlhv.list_header_id price_list_id, qlhv.name name, qlhv.description description, qlhv.start_date_active start_date_active, qlhv.end_date_active end_date_active , qdt.start_date_active qdt_start_date_active, qdt.end_date_active qdt_end_date_active , qdt.to_currency_code currency_code, -9999 agreement_id, -9999 sold_to_org_id, qlhv.source_system_code, qlhv.shareable_flag, qlhv.orig_system_header_ref, qlhv.list_source_code, 1 qry_type, qlhv.global_flag, qlhv.orig_org_id FROM qp_list_headers_vl qlhv, qp_currency_details qdt WHERE qlhv.currency_header_id = qdt.currency_header_id AND qlhv.active_flag = 'Y' AND qlhv.list_type_code = 'PRL' UNION ALL SELECT qlhv.list_header_id price_list_id, qlhv.name name, qlhv.description description, qlhv.start_date_active start_date_active, qlhv.end_date_active end_date_active , qdt.start_date_active qdt_start_date_active, qdt.end_date_active qdt_end_date_active , qdt.to_currency_code currency_code, oab.agreement_id, oab.sold_to_org_id, qlhv.source_system_code, qlhv.shareable_flag, qlhv.orig_system_header_ref, qlhv.list_source_code, 1 qry_type, qlhv.global_flag, qlhv.orig_org_id FROM qp_list_headers_vl qlhv, oe_agreements_b oab, qp_currency_details qdt WHERE qlhv.currency_header_id = qdt.currency_header_id AND qlhv.list_type_code ='AGR' AND qlhv.active_flag = 'Y' AND qlhv.list_header_id = oab.price_list_id UNION ALL SELECT qlhv.list_header_id price_list_id, qlhv.name name, qlhv.description description, qlhv.start_date_active start_date_active, qlhv.end_date_active end_date_active , (SYSDATE-730000) qdt_start_date_active, (SYSDATE-730000) qdt_end_date_active , qlhv.currency_code currency_code, -9999 agreement_id, -9999 sold_to_org_id, qlhv.source_system_code, qlhv.shareable_flag, qlhv.orig_system_header_ref, qlhv.list_source_code, 2 qry_type, qlhv.global_flag, qlhv.orig_org_id FROM qp_list_headers_vl qlhv WHERE qlhv.active_flag = 'Y' AND qlhv.list_type_code = 'PRL' UNION ALL SELECT qlhv.list_header_id price_list_id, qlhv.name name, qlhv.description description, qlhv.start_date_active start_date_active, qlhv.end_date_active end_date_active , (SYSDATE-730000) qdt_start_date_active, (SYSDATE-730000) qdt_end_date_active , qlhv.currency_code currency_code, oab.agreement_id, oab.sold_to_org_id, qlhv.source_system_code, qlhv.shareable_flag, qlhv.orig_system_header_ref, qlhv.list_source_code, 2 qry_type, qlhv.global_flag, qlhv.orig_org_id FROM qp_list_headers_vl qlhv, oe_agreements_b oab WHERE qlhv.list_type_code ='AGR' AND qlhv.active_flag = 'Y' AND qlhv.list_header_id = oab.price_list_id

View Text - HTML Formatted

SELECT QLHV.LIST_HEADER_ID PRICE_LIST_ID
, QLHV.NAME NAME
, QLHV.DESCRIPTION DESCRIPTION
, QLHV.START_DATE_ACTIVE START_DATE_ACTIVE
, QLHV.END_DATE_ACTIVE END_DATE_ACTIVE
, QDT.START_DATE_ACTIVE QDT_START_DATE_ACTIVE
, QDT.END_DATE_ACTIVE QDT_END_DATE_ACTIVE
, QDT.TO_CURRENCY_CODE CURRENCY_CODE
, -9999 AGREEMENT_ID
, -9999 SOLD_TO_ORG_ID
, QLHV.SOURCE_SYSTEM_CODE
, QLHV.SHAREABLE_FLAG
, QLHV.ORIG_SYSTEM_HEADER_REF
, QLHV.LIST_SOURCE_CODE
, 1 QRY_TYPE
, QLHV.GLOBAL_FLAG
, QLHV.ORIG_ORG_ID
FROM QP_LIST_HEADERS_VL QLHV
, QP_CURRENCY_DETAILS QDT
WHERE QLHV.CURRENCY_HEADER_ID = QDT.CURRENCY_HEADER_ID
AND QLHV.ACTIVE_FLAG = 'Y'
AND QLHV.LIST_TYPE_CODE = 'PRL' UNION ALL SELECT QLHV.LIST_HEADER_ID PRICE_LIST_ID
, QLHV.NAME NAME
, QLHV.DESCRIPTION DESCRIPTION
, QLHV.START_DATE_ACTIVE START_DATE_ACTIVE
, QLHV.END_DATE_ACTIVE END_DATE_ACTIVE
, QDT.START_DATE_ACTIVE QDT_START_DATE_ACTIVE
, QDT.END_DATE_ACTIVE QDT_END_DATE_ACTIVE
, QDT.TO_CURRENCY_CODE CURRENCY_CODE
, OAB.AGREEMENT_ID
, OAB.SOLD_TO_ORG_ID
, QLHV.SOURCE_SYSTEM_CODE
, QLHV.SHAREABLE_FLAG
, QLHV.ORIG_SYSTEM_HEADER_REF
, QLHV.LIST_SOURCE_CODE
, 1 QRY_TYPE
, QLHV.GLOBAL_FLAG
, QLHV.ORIG_ORG_ID
FROM QP_LIST_HEADERS_VL QLHV
, OE_AGREEMENTS_B OAB
, QP_CURRENCY_DETAILS QDT
WHERE QLHV.CURRENCY_HEADER_ID = QDT.CURRENCY_HEADER_ID
AND QLHV.LIST_TYPE_CODE ='AGR'
AND QLHV.ACTIVE_FLAG = 'Y'
AND QLHV.LIST_HEADER_ID = OAB.PRICE_LIST_ID UNION ALL SELECT QLHV.LIST_HEADER_ID PRICE_LIST_ID
, QLHV.NAME NAME
, QLHV.DESCRIPTION DESCRIPTION
, QLHV.START_DATE_ACTIVE START_DATE_ACTIVE
, QLHV.END_DATE_ACTIVE END_DATE_ACTIVE
, (SYSDATE-730000) QDT_START_DATE_ACTIVE
, (SYSDATE-730000) QDT_END_DATE_ACTIVE
, QLHV.CURRENCY_CODE CURRENCY_CODE
, -9999 AGREEMENT_ID
, -9999 SOLD_TO_ORG_ID
, QLHV.SOURCE_SYSTEM_CODE
, QLHV.SHAREABLE_FLAG
, QLHV.ORIG_SYSTEM_HEADER_REF
, QLHV.LIST_SOURCE_CODE
, 2 QRY_TYPE
, QLHV.GLOBAL_FLAG
, QLHV.ORIG_ORG_ID
FROM QP_LIST_HEADERS_VL QLHV
WHERE QLHV.ACTIVE_FLAG = 'Y'
AND QLHV.LIST_TYPE_CODE = 'PRL' UNION ALL SELECT QLHV.LIST_HEADER_ID PRICE_LIST_ID
, QLHV.NAME NAME
, QLHV.DESCRIPTION DESCRIPTION
, QLHV.START_DATE_ACTIVE START_DATE_ACTIVE
, QLHV.END_DATE_ACTIVE END_DATE_ACTIVE
, (SYSDATE-730000) QDT_START_DATE_ACTIVE
, (SYSDATE-730000) QDT_END_DATE_ACTIVE
, QLHV.CURRENCY_CODE CURRENCY_CODE
, OAB.AGREEMENT_ID
, OAB.SOLD_TO_ORG_ID
, QLHV.SOURCE_SYSTEM_CODE
, QLHV.SHAREABLE_FLAG
, QLHV.ORIG_SYSTEM_HEADER_REF
, QLHV.LIST_SOURCE_CODE
, 2 QRY_TYPE
, QLHV.GLOBAL_FLAG
, QLHV.ORIG_ORG_ID
FROM QP_LIST_HEADERS_VL QLHV
, OE_AGREEMENTS_B OAB
WHERE QLHV.LIST_TYPE_CODE ='AGR'
AND QLHV.ACTIVE_FLAG = 'Y'
AND QLHV.LIST_HEADER_ID = OAB.PRICE_LIST_ID