VIEW: APPS.AMS_PRICE_LIST_LINES_V

Source

View Text - Preformatted

SELECT qpll.list_line_id, qpll.list_header_id, qpa.pricing_attribute_id, qpa.product_attr_value, qpll.product_precedence, qpa.product_uom_code, qpll.operand, qpll.start_date_active, qpll.end_date_active, msi.padded_concatenated_segments, msi.concatenated_segments, msi.description item_description, qpll.comments FROM mtl_system_items_kfv msi, qp_pricing_attributes qpa, qp_list_lines qpll WHERE qpa.product_attr_value = to_char(msi.inventory_item_id) AND qpa.product_attribute_context = 'ITEM' AND qpa.excluder_flag = 'N' AND msi.organization_id = TO_NUMBER(FND_PROFILE.VALUE('QP_ORGANIZATION_ID')) AND qpll.list_line_id = qpa.list_line_id AND qpll.list_line_type_code = 'PLL'

View Text - HTML Formatted

SELECT QPLL.LIST_LINE_ID
, QPLL.LIST_HEADER_ID
, QPA.PRICING_ATTRIBUTE_ID
, QPA.PRODUCT_ATTR_VALUE
, QPLL.PRODUCT_PRECEDENCE
, QPA.PRODUCT_UOM_CODE
, QPLL.OPERAND
, QPLL.START_DATE_ACTIVE
, QPLL.END_DATE_ACTIVE
, MSI.PADDED_CONCATENATED_SEGMENTS
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION ITEM_DESCRIPTION
, QPLL.COMMENTS
FROM MTL_SYSTEM_ITEMS_KFV MSI
, QP_PRICING_ATTRIBUTES QPA
, QP_LIST_LINES QPLL
WHERE QPA.PRODUCT_ATTR_VALUE = TO_CHAR(MSI.INVENTORY_ITEM_ID)
AND QPA.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
AND QPA.EXCLUDER_FLAG = 'N'
AND MSI.ORGANIZATION_ID = TO_NUMBER(FND_PROFILE.VALUE('QP_ORGANIZATION_ID'))
AND QPLL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QPLL.LIST_LINE_TYPE_CODE = 'PLL'