View: ICX_OE_DIRECT_ITEMS_V

Product:	ICX - Oracle iProcurement
Description:	Web Store - Direct Item Entry View
Implementation/DBA Data:	APPS.ICX_OE_DIRECT_ITEMS_V

View Text

SELECT PLL.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, NULL
, MUOM.UNIT_OF_MEASURE
, PLL.LIST_PRICE
, PLL.PRICE_LIST_ID
, PLL.PRICE_LIST_LINE_ID
, ICX.ORG_ID
, MCIS.CUSTOMER_ID
, MCIS.ADDRESS_ID
, MCIX.CUSTOMER_ITEM_ID
, MCIS.CUSTOMER_ITEM_NUMBER
, MCIS.CUSTOMER_CATEGORY_CODE
, MCIS.ITEM_DEFINITION_LEVEL
, MTP.MASTER_ORGANIZATION_ID
, PLL.START_DATE_ACTIVE
, PLL.END_DATE_ACTIVE
FROM MTL_ITEM_CATEGORIES MIC
, MTL_SYSTEM_ITEMS_KFV MSI
, FND_PROFILE_OPTION_VALUES FPOV
, FND_PROFILE_OPTION_VALUES FPOV2
, SO_PRICE_LIST_LINES PLL
, FND_PROFILE_OPTIONS FPO
, FND_PROFILE_OPTIONS FPO2
, MTL_CUSTOMER_ITEMS MCIS
, MTL_CUSTOMER_ITEM_XREFS MCIX
, MTL_UNITS_OF_MEASURE MUOM
, MTL_PARAMETERS MTP
, ICX_WEB_STORE_OPTIONS ICX
WHERE PLL.UNIT_CODE = MUOM.UOM_CODE
AND MSI.INVENTORY_ITEM_ID = PLL.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = FPOV2.PROFILE_OPTION_VALUE
AND MSI.BOM_ITEM_TYPE IN (4
, 1)
AND ((FPOV.PROFILE_OPTION_VALUE = 'Y'
AND MSI.CUSTOMER_ORDER_ENABLED_FLAG = 'Y') OR FPOV.PROFILE_OPTION_VALUE = 'N')
AND FPO.PROFILE_OPTION_NAME = 'OE_VALIDATE_STANDARD_LINE_ITEM'
AND FPO.START_DATE_ACTIVE <= SYSDATE
AND NVL(FPO.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE
AND FPOV.APPLICATION_ID = 300
AND FPOV.LEVEL_ID=10002
AND FPOV.LEVEL_VALUE = 300
AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID
AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MIC.ORGANIZATION_ID = FPOV2.PROFILE_OPTION_VALUE
AND MIC.CATEGORY_SET_ID = ICX.CATEGORY_SET_ID
AND FPO2.PROFILE_OPTION_NAME = 'SO_ORGANIZATION_ID'
AND FPO2.APPLICATION_ID = 300
AND FPO2.START_DATE_ACTIVE <= SYSDATE
AND NVL(FPO2.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE
AND FPO2.PROFILE_OPTION_ID = FPOV2.PROFILE_OPTION_ID
AND FPOV2.APPLICATION_ID = 300
AND FPOV2.LEVEL_ID = 10001
AND FPOV2.LEVEL_VALUE = 0
AND PLL.PRICING_ATTRIBUTE1 IS NULL
AND PLL.PRICING_ATTRIBUTE2 IS NULL
AND PLL.PRICING_ATTRIBUTE3 IS NULL
AND PLL.PRICING_ATTRIBUTE4 IS NULL
AND PLL.PRICING_ATTRIBUTE5 IS NULL
AND PLL.PRICING_ATTRIBUTE6 IS NULL
AND PLL.PRICING_ATTRIBUTE7 IS NULL
AND PLL.PRICING_ATTRIBUTE8 IS NULL
AND PLL.PRICING_ATTRIBUTE9 IS NULL
AND PLL.PRICING_ATTRIBUTE10 IS NULL
AND PLL.PRICING_ATTRIBUTE11 IS NULL
AND PLL.PRICING_ATTRIBUTE12 IS NULL
AND PLL.PRICING_ATTRIBUTE13 IS NULL
AND PLL.PRICING_ATTRIBUTE14 IS NULL
AND PLL.PRICING_ATTRIBUTE15 IS NULL
AND MCIX.INVENTORY_ITEM_ID (+) = MSI.INVENTORY_ITEM_ID
AND MTP.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND NVL(MCIX.MASTER_ORGANIZATION_ID
, MTP.MASTER_ORGANIZATION_ID) = MTP.MASTER_ORGANIZATION_ID
AND NVL(MCIX.INACTIVE_FLAG
, 'N') = 'N'
AND MCIS.CUSTOMER_ITEM_ID (+)= MCIX.CUSTOMER_ITEM_ID

Columns