VIEW: APPS.AMS_PRODUCT_PRICING_V

Source

View Text - Preformatted

SELECT qlh.list_header_id list_header_id ,qll.list_line_id list_line_id ,qlh.name Name,qlh.currency_code Currency ,qll.start_date_active Start_date ,qll.end_date_active End_date ,qll.list_price Unit_Price ,qll.operand operand ,qpa.product_uom_code Unit ,AMS_utility_pvt.get_uom_name(qpa.product_uom_code) Unit_of_measure ,qpa.pricing_attribute_id pricing_attribute_id ,la.status_code status_code ,la.user_status_id user_status_id ,ozf_price_list_pvt.get_user_status_name(la.user_status_id) user_status_name ,qpa.product_attr_value Product_id ,ia.item_owner_id item_owner_id ,qlh.description description ,msi.concatenated_segments product_name ,la.owner_id ,qll.generate_using_formula_id ,qll.price_by_formula_id FROM qp_list_headers_v qlh ,qp_list_lines qll ,qp_pricing_attributes qpa ,ozf_price_list_attributes la ,ams_item_attributes ia ,mtl_system_items_kfv msi WHERE qlh.list_header_id = la.qp_list_header_id(+) AND msi.organization_id = TO_NUMBER(FND_PROFILE.VALUE('QP_ORGANIZATION_ID')) AND msi.inventory_item_id = ia.inventory_item_id AND qlh.list_header_id = qll.list_header_id AND qll.list_line_id = qpa.list_line_id AND qpa.Product_attr_value = to_char(ia.inventory_item_id) AND qpa.product_attribute_context = 'ITEM' AND qpa.excluder_flag = 'N'

View Text - HTML Formatted

SELECT QLH.LIST_HEADER_ID LIST_HEADER_ID
, QLL.LIST_LINE_ID LIST_LINE_ID
, QLH.NAME NAME
, QLH.CURRENCY_CODE CURRENCY
, QLL.START_DATE_ACTIVE START_DATE
, QLL.END_DATE_ACTIVE END_DATE
, QLL.LIST_PRICE UNIT_PRICE
, QLL.OPERAND OPERAND
, QPA.PRODUCT_UOM_CODE UNIT
, AMS_UTILITY_PVT.GET_UOM_NAME(QPA.PRODUCT_UOM_CODE) UNIT_OF_MEASURE
, QPA.PRICING_ATTRIBUTE_ID PRICING_ATTRIBUTE_ID
, LA.STATUS_CODE STATUS_CODE
, LA.USER_STATUS_ID USER_STATUS_ID
, OZF_PRICE_LIST_PVT.GET_USER_STATUS_NAME(LA.USER_STATUS_ID) USER_STATUS_NAME
, QPA.PRODUCT_ATTR_VALUE PRODUCT_ID
, IA.ITEM_OWNER_ID ITEM_OWNER_ID
, QLH.DESCRIPTION DESCRIPTION
, MSI.CONCATENATED_SEGMENTS PRODUCT_NAME
, LA.OWNER_ID
, QLL.GENERATE_USING_FORMULA_ID
, QLL.PRICE_BY_FORMULA_ID
FROM QP_LIST_HEADERS_V QLH
, QP_LIST_LINES QLL
, QP_PRICING_ATTRIBUTES QPA
, OZF_PRICE_LIST_ATTRIBUTES LA
, AMS_ITEM_ATTRIBUTES IA
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE QLH.LIST_HEADER_ID = LA.QP_LIST_HEADER_ID(+)
AND MSI.ORGANIZATION_ID = TO_NUMBER(FND_PROFILE.VALUE('QP_ORGANIZATION_ID'))
AND MSI.INVENTORY_ITEM_ID = IA.INVENTORY_ITEM_ID
AND QLH.LIST_HEADER_ID = QLL.LIST_HEADER_ID
AND QLL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QPA.PRODUCT_ATTR_VALUE = TO_CHAR(IA.INVENTORY_ITEM_ID)
AND QPA.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
AND QPA.EXCLUDER_FLAG = 'N'