VIEW: APPS.ICX_ITEM_DETLS_INFO_V

Source

View Text - Preformatted

SELECT DISTINCT(PLL.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID , MSI.CONCATENATED_SEGMENTS , MSI.DESCRIPTION , IDI.TEMPLATE_BUSINESS , IDI.TEMPLATE_CONSUMER , IDI.MARKETING_TEXT_FILE , IDI.MARKETING_TEXT , IDI.SPECIAL_FLAG_BUSINESS , IDI.SPECIAL_IMAGE_BUSINESS , IDI.SPECIAL_TEXT_BUSINESS , IDI.SPECIAL_THUMBNAIL_BUSINESS , IDI.SPECIAL_START_DATE_BUSINESS , IDI.SPECIAL_END_DATE_BUSINESS , IDI.SPECIAL_FLAG_CONSUMER , IDI.SPECIAL_IMAGE_CONSUMER , IDI.SPECIAL_TEXT_CONSUMER , IDI.SPECIAL_THUMBNAIL_CONSUMER , IDI.SPECIAL_START_DATE_CONSUMER , IDI.SPECIAL_END_DATE_CONSUMER , IDI.IMAGE_FILE_1 , IDI.IMAGE_FILE_2 , IDI.IMAGE_FILE_3 , IDI.IMAGE_FILE_4 , IDI.IMAGE_FILE_5 , IDI.IMAGE_FILE_6 , IDI.IMAGE_FILE_7 , IDI.IMAGE_FILE_8 , IDI.IMAGE_FILE_9 , IDI.IMAGE_FILE_10 , IDI.IMAGE_FILE_11 , IDI.IMAGE_FILE_12 , IDI.IMAGE_FILE_13 , IDI.IMAGE_FILE_14 , IDI.IMAGE_FILE_15 FROM ICX_ITEM_DETLS_INFO_VL IDI, FND_PROFILE_OPTIONS FPO, FND_PROFILE_OPTION_VALUES FPOV, MTL_PARAMETERS MTP, SO_PRICE_LIST_LINES PLL, SO_PRICE_LISTS PLC, MTL_CUSTOMER_ITEMS MCIS, MTL_CUSTOMER_ITEM_XREFS MCIX, MTL_UNITS_OF_MEASURE MUOM, MTL_SYSTEM_ITEMS_KFV MSI, MTL_ITEM_CATEGORIES MIC WHERE PLL.INVENTORY_ITEM_ID = IDI.INVENTORY_ITEM_ID (+) AND MIC.ORGANIZATION_ID = NVL(PROFILE_OPTION_VALUE,-1) AND FPO.START_DATE_ACTIVE <= SYSDATE AND NVL(FPO.END_DATE_ACTIVE,SYSDATE) >= SYSDATE AND FPO.PROFILE_OPTION_NAME = 'SO_ORGANIZATION_ID' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.APPLICATION_ID = 300 AND FPOV.LEVEL_ID = 10001 AND FPOV.LEVEL_VALUE = 0 AND PLL.UNIT_CODE = MUOM.UOM_CODE AND PLL.PRICE_LIST_ID = PLC.PRICE_LIST_ID AND MSI.INVENTORY_ITEM_ID = PLL.INVENTORY_ITEM_ID AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND (MSI.BOM_ITEM_TYPE = 4 OR MSI.BOM_ITEM_TYPE = 1) AND MIC.ORGANIZATION_ID = MSI.ORGANIZATION_ID 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 MCIX.INACTIVE_FLAG(+) = 'N' AND MCIS.CUSTOMER_ITEM_ID (+)= MCIX.CUSTOMER_ITEM_ID

View Text - HTML Formatted

SELECT DISTINCT(PLL.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, IDI.TEMPLATE_BUSINESS
, IDI.TEMPLATE_CONSUMER
, IDI.MARKETING_TEXT_FILE
, IDI.MARKETING_TEXT
, IDI.SPECIAL_FLAG_BUSINESS
, IDI.SPECIAL_IMAGE_BUSINESS
, IDI.SPECIAL_TEXT_BUSINESS
, IDI.SPECIAL_THUMBNAIL_BUSINESS
, IDI.SPECIAL_START_DATE_BUSINESS
, IDI.SPECIAL_END_DATE_BUSINESS
, IDI.SPECIAL_FLAG_CONSUMER
, IDI.SPECIAL_IMAGE_CONSUMER
, IDI.SPECIAL_TEXT_CONSUMER
, IDI.SPECIAL_THUMBNAIL_CONSUMER
, IDI.SPECIAL_START_DATE_CONSUMER
, IDI.SPECIAL_END_DATE_CONSUMER
, IDI.IMAGE_FILE_1
, IDI.IMAGE_FILE_2
, IDI.IMAGE_FILE_3
, IDI.IMAGE_FILE_4
, IDI.IMAGE_FILE_5
, IDI.IMAGE_FILE_6
, IDI.IMAGE_FILE_7
, IDI.IMAGE_FILE_8
, IDI.IMAGE_FILE_9
, IDI.IMAGE_FILE_10
, IDI.IMAGE_FILE_11
, IDI.IMAGE_FILE_12
, IDI.IMAGE_FILE_13
, IDI.IMAGE_FILE_14
, IDI.IMAGE_FILE_15
FROM ICX_ITEM_DETLS_INFO_VL IDI
, FND_PROFILE_OPTIONS FPO
, FND_PROFILE_OPTION_VALUES FPOV
, MTL_PARAMETERS MTP
, SO_PRICE_LIST_LINES PLL
, SO_PRICE_LISTS PLC
, MTL_CUSTOMER_ITEMS MCIS
, MTL_CUSTOMER_ITEM_XREFS MCIX
, MTL_UNITS_OF_MEASURE MUOM
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_ITEM_CATEGORIES MIC
WHERE PLL.INVENTORY_ITEM_ID = IDI.INVENTORY_ITEM_ID (+)
AND MIC.ORGANIZATION_ID = NVL(PROFILE_OPTION_VALUE
, -1)
AND FPO.START_DATE_ACTIVE <= SYSDATE
AND NVL(FPO.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE
AND FPO.PROFILE_OPTION_NAME = 'SO_ORGANIZATION_ID'
AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID
AND FPOV.APPLICATION_ID = 300
AND FPOV.LEVEL_ID = 10001
AND FPOV.LEVEL_VALUE = 0
AND PLL.UNIT_CODE = MUOM.UOM_CODE
AND PLL.PRICE_LIST_ID = PLC.PRICE_LIST_ID
AND MSI.INVENTORY_ITEM_ID = PLL.INVENTORY_ITEM_ID
AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND (MSI.BOM_ITEM_TYPE = 4 OR MSI.BOM_ITEM_TYPE = 1)
AND MIC.ORGANIZATION_ID = MSI.ORGANIZATION_ID
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 MCIX.INACTIVE_FLAG(+) = 'N'
AND MCIS.CUSTOMER_ITEM_ID (+)= MCIX.CUSTOMER_ITEM_ID