VIEW: APPS.QP_CRMINTEG_PRICELIST_V

Source

View Text - Preformatted

SELECT qplh.list_header_id, qplh.name, qplh.currency_code, qplh.start_date_active HEADER_START_DATE, qplh.end_date_active HEADER_END_DATE, qplh.orig_org_id, (select name from hr_operating_units hou where hou.organization_id = qplh.orig_org_id) ou_name, qplh.ship_method_code, qplh.freight_terms_code, qplh.description, qll.list_line_id, qll.start_date_active LINE_START_DATE, qll.end_date_active LINE_END_DATE, qpa.product_attr_value, qpa.product_uom_code, qll.operand, msib.inventory_item_id, msib.concatenated_segments, mp.organization_id, mp.ORGANIZATION_CODE, qplh.ACTIVE_FLAG from qp_list_headers_vl qplh, qp_list_lines qll, mtl_system_items_b_kfv msib, mtl_parameters mp, qp_pricing_attributes qpa WHERE qplh.list_header_id = qll.list_header_id and qll.list_line_id = qpa.list_line_id and qplh.list_type_code = 'PRL' and qplh.pte_code ='ORDFUL' and qll.list_line_type_code ='PLL' and qpa.product_attribute_context = 'ITEM' and qpa.product_attribute = 'PRICING_ATTRIBUTE1' and qpa.pricing_attribute_context is null and qpa.pricing_attribute is null and qpa.pricing_attr_value_from is null and qll.list_line_id not in (select to_rltd_modifier_id from qp_rltd_modifiers where from_rltd_modifier_id in (select list_line_id from qp_list_lines where list_line_type_code = 'PBH')) and qll.price_by_formula_id is null and msib.inventory_item_id = to_number(qpa.product_attr_value) and msib.organization_id =fnd_profile.value('QP_ORGANIZATION_ID') and msib.organization_id = mp.organization_id and qll.pricing_phase_id = 1 and qll.qualification_ind = 4 and qll.generate_using_formula_id is null and qpa.product_uom_code = msib.primary_uom_code

View Text - HTML Formatted

SELECT QPLH.LIST_HEADER_ID
, QPLH.NAME
, QPLH.CURRENCY_CODE
, QPLH.START_DATE_ACTIVE HEADER_START_DATE
, QPLH.END_DATE_ACTIVE HEADER_END_DATE
, QPLH.ORIG_ORG_ID
, (SELECT NAME
FROM HR_OPERATING_UNITS HOU
WHERE HOU.ORGANIZATION_ID = QPLH.ORIG_ORG_ID) OU_NAME
, QPLH.SHIP_METHOD_CODE
, QPLH.FREIGHT_TERMS_CODE
, QPLH.DESCRIPTION
, QLL.LIST_LINE_ID
, QLL.START_DATE_ACTIVE LINE_START_DATE
, QLL.END_DATE_ACTIVE LINE_END_DATE
, QPA.PRODUCT_ATTR_VALUE
, QPA.PRODUCT_UOM_CODE
, QLL.OPERAND
, MSIB.INVENTORY_ITEM_ID
, MSIB.CONCATENATED_SEGMENTS
, MP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, QPLH.ACTIVE_FLAG
FROM QP_LIST_HEADERS_VL QPLH
, QP_LIST_LINES QLL
, MTL_SYSTEM_ITEMS_B_KFV MSIB
, MTL_PARAMETERS MP
, QP_PRICING_ATTRIBUTES QPA
WHERE QPLH.LIST_HEADER_ID = QLL.LIST_HEADER_ID
AND QLL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QPLH.LIST_TYPE_CODE = 'PRL'
AND QPLH.PTE_CODE ='ORDFUL'
AND QLL.LIST_LINE_TYPE_CODE ='PLL'
AND QPA.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
AND QPA.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE1'
AND QPA.PRICING_ATTRIBUTE_CONTEXT IS NULL
AND QPA.PRICING_ATTRIBUTE IS NULL
AND QPA.PRICING_ATTR_VALUE_FROM IS NULL
AND QLL.LIST_LINE_ID NOT IN (SELECT TO_RLTD_MODIFIER_ID
FROM QP_RLTD_MODIFIERS
WHERE FROM_RLTD_MODIFIER_ID IN (SELECT LIST_LINE_ID
FROM QP_LIST_LINES
WHERE LIST_LINE_TYPE_CODE = 'PBH'))
AND QLL.PRICE_BY_FORMULA_ID IS NULL
AND MSIB.INVENTORY_ITEM_ID = TO_NUMBER(QPA.PRODUCT_ATTR_VALUE)
AND MSIB.ORGANIZATION_ID =FND_PROFILE.VALUE('QP_ORGANIZATION_ID')
AND MSIB.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND QLL.PRICING_PHASE_ID = 1
AND QLL.QUALIFICATION_IND = 4
AND QLL.GENERATE_USING_FORMULA_ID IS NULL
AND QPA.PRODUCT_UOM_CODE = MSIB.PRIMARY_UOM_CODE