VIEW: APPS.AMS_PRODUCT_PRL_IMP_V

Source

View Text - Preformatted

SELECT qlh.name, to_number(qpa.product_attr_value), qll.list_line_id, qlh.list_header_id, qlh.currency_code, qpa.product_uom_code, AMS_utility_pvt.get_uom_name(qpa.product_uom_code), qll.operand FROM qp_list_headers_v qlh , qp_list_lines qll , qp_pricing_attributes qpa WHERE qlh.list_header_id = qll.list_header_id AND qll.list_line_id = qpa.list_line_id AND qpa.product_attribute_context = 'ITEM' AND qpa.excluder_flag = 'N'

View Text - HTML Formatted

SELECT QLH.NAME
, TO_NUMBER(QPA.PRODUCT_ATTR_VALUE)
, QLL.LIST_LINE_ID
, QLH.LIST_HEADER_ID
, QLH.CURRENCY_CODE
, QPA.PRODUCT_UOM_CODE
, AMS_UTILITY_PVT.GET_UOM_NAME(QPA.PRODUCT_UOM_CODE)
, QLL.OPERAND
FROM QP_LIST_HEADERS_V QLH
, QP_LIST_LINES QLL
, QP_PRICING_ATTRIBUTES QPA
WHERE QLH.LIST_HEADER_ID = QLL.LIST_HEADER_ID
AND QLL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QPA.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
AND QPA.EXCLUDER_FLAG = 'N'