Wednesday, September 28, 2016

Price list setup Query

SELECT h.DESCRIPTION,
  h.CURRENCY_CODE,
  h.ACTIVE_FLAG,
  h.LAST_UPDATE_DATE,
  h.ROUNDING_FACTOR,
  h.FREIGHT_TERMS_CODE,
  h.PTE_CODE,
  h.COMMENTS,
  L.LIST_PRICE_UOM_CODE,
  L.PRIMARY_UOM_FLAG,
  L.LIST_PRICE,
  L.LIST_LINE_TYPE_CODE,
  L.OPERAND ,
  L. START_DATE_ACTIVE,
  L.PRODUCT_PRECEDENCE PRODUCT_VALUE ,
  L.ARITHMETIC_OPERATOR APPLICATION_METHOD,
  L. ATTRIBUTE1 INITIAL_PRICE,
  L.ATTRIBUTE2 INCREMENTS,
  L.ATTRIBUTE3 RETAIL_PRICE,
  L. ATTRIBUTE4 CLSS,
  L.ATTRIBUTE5 DIVISION,
  L.ATTRIBUTE6 DEPARTMENT,
  L. ATTRIBUTE7 VENDOR_SLOT,
  L. ATTRIBUTE8 COUNTRY_OF_ORIGIN,
  L. ATTRIBUTE9 LABEL_NAME1,
  L. ATTRIBUTE10 LABEL_NAME2,
  L. ATTRIBUTE14 PR_NUMBER1,
  L.ATTRIBUTE15 PR_NUMBER2,
  F.NAME,
  I.DESCRIPTION product_description,
  I.SEGMENT1
  ||'.'
  ||I.SEGMENT2 PRODUCT_VALUE,
  A.PRODUCT_ATTRIBUTE_CONTEXT PRODUCT_CONTEXT,
  A.PRODUCT_ATTRIBUTE PRODUCT_ATTRIBUTE,
  A.PRODUCT_ATTR_VALUE PRODUCT_VALUE,
  A.PRICING_ATTRIBUTE_CONTEXT PRICING_CONTEXT,
  A.PRICING_ATTRIBUTE,
  A.COMPARISON_OPERATOR_CODE OPERATOR,
  A.PRICING_ATTR_VALUE_FROM VALUE_FROM,
  A.PRICING_ATTR_VALUE_TO VALUE_TO
FROM qp_list_headers h,
  QP_LIST_LINES L,
  QP_PRICE_FORMULAS_TL F,
  mtl_system_items_b I,
  QP_PRICING_ATTRIBUTES A
WHERE H.LIST_HEADER_ID               =L.LIST_HEADER_ID
AND L.GENERATE_USING_FORMULA_ID      =F.PRICE_FORMULA_ID
AND TO_NUMBER (A.product_attr_value) = I.inventory_item_id
AND TO_NUMBER(A.LIST_LINE_ID)        =L.LIST_LINE_ID
AND I.organization_id                =
  (SELECT qp_util.get_item_validation_org FROM DUAL
  ); 

No comments:

Post a Comment