Product: | XNC - Sales for Communications (Obsolete) |
---|---|
Description: | XNC_PRICELIST_ITEM_V retrieves price lists, other than adjustment or discount lists, available for an Inventory Item. |
Implementation/DBA Data: | Not implemented in this database |
SELECT DISTINCT A.ROW_ID
, A.LIST_HEADER_ID
, A.NAME
, A.CURRENCY_CODE
, A.ROUNDING_FACTOR
, A.SHIP_METHOD_CODE
, A.FREIGHT_TERMS_CODE
, A.TERMS_ID
, A.QPH_START_DATE_ACTIVE
, A.QPH_END_DATE_ACTIVE
, A.DESCRIPTION
, A.LIST_LINE_ID
, A.ARITHMETIC_OPERATOR
, A.OPERAND
, A.LINE_COMMENTS
, A.PRODUCT_ATTRIBUTE_CONTEXT
, A.PRODUCT_ATTRIBUTE
, M.INVENTORY_ITEM_ID
, M.PADDED_CONCATENATED_SEGMENTS
, A.PRODUCT_UOM_CODE
FROM QP_LIST_ATTRIBUTES_V A
, MTL_SYSTEM_ITEMS_KFV M
WHERE A.LIST_TYPE_CODE = 'PRL' AND A.LIST_LINE_TYPE_CODE = 'PLL' AND A.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM' AND TO_CHAR(M.INVENTORY_ITEM_ID) = A.PRODUCT_ATTR_VALUE AND (NVL(TRUNC(A.QPH_START_DATE_ACTIVE)
, TRUNC(SYSDATE)) <= TRUNC(SYSDATE))
AND (NVL(TRUNC(A.QPH_END_DATE_ACTIVE)
, TRUNC(SYSDATE)) >= TRUNC(SYSDATE))