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
);
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