View: QP_CUSTOMER_ITEMS_V

Product:	QP - Advanced Pricing
Description:	Customer item details. Used in the Pricing Agreements form.
Implementation/DBA Data:	APPS.QP_CUSTOMER_ITEMS_V

View Text

SELECT CITEMSV.CUSTOMER_ITEM_NUMBER CUSTOMER_ITEM
, CITEMSV.CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, NVL(CITEMSV.CUSTOMER_ITEM_DESC
, SITEMS.DESCRIPTION) ITEM_DESCRIPTION
, SUBSTR(CITEMSV.CONCATENATED_ADDRESS
, 1
, 400) ADDRESS
, SITEMS.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SITEMS.CONCATENATED_SEGMENTS INVENTORY_ITEM
, CITEMSV.CUSTOMER_ID SOLD_TO_ORG_ID
, SITEMS.ORGANIZATION_ID ORGANIZATION_ID
, CITEMSV.CUSTOMER_CATEGORY
, CITEMSV.ADDRESS_ID
FROM MTL_CUSTOMER_ITEM_XREFS CXREF
, MTL_SYSTEM_ITEMS_VL SITEMS
, MTL_CUSTOMER_ITEMS_ALL_V CITEMSV
WHERE CITEMSV.CUSTOMER_ITEM_ID = CXREF.CUSTOMER_ITEM_ID
AND CXREF.INVENTORY_ITEM_ID = SITEMS.INVENTORY_ITEM_ID
AND SITEMS.ORGANIZATION_ID = FND_PROFILE.VALUE('QP_ORGANIZATION_ID')

Columns