View: AST_INV_ITEM_LOV_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_INV_ITEM_LOV_V

View Text

SELECT /*+ ORDERED FIRST_ROWS */ B.CONCATENATED_SEGMENTS ITEM_CONCAT_SEGS
, ITEM.DESCRIPTION ITEM_DESCRIPTION
, ITEM.INVENTORY_ITEM_ID
, MIC.CATEGORY_ID
, MIC.ORGANIZATION_ID
, P.CONCAT_CAT_PARENTAGE CONCATENATED_CAT_DESC
, P.CATEGORY_ID PRODUCT_CATEGORY_ID
, P.CATEGORY_SET_ID PRODUCT_CAT_SET_ID
, NULL INTEREST_TYPE_ID
, NULL PRIMARY_INTEREST_CODE_ID
, NULL SECONDARY_INTEREST_CODE_ID
, NULL INTEREST_TYPE
, NULL PRIMARY_INTEREST_CODE
, NULL SECONDARY_INTEREST_CODE
FROM MTL_SYSTEM_ITEMS_B_KFV B
, MTL_SYSTEM_ITEMS_TL ITEM
, MTL_ITEM_CATEGORIES MIC
, ENI_PROD_DEN_HRCHY_PARENTS_V P
WHERE MIC.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND MIC.ORGANIZATION_ID = B.ORGANIZATION_ID
AND B.ORGANIZATION_ID = ITEM.ORGANIZATION_ID
AND B.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID
AND ITEM.LANGUAGE = USERENV('LANG')
AND P.CATEGORY_ID = MIC.CATEGORY_ID
AND P.CATEGORY_SET_ID = MIC.CATEGORY_SET_ID
AND P.LANGUAGE = USERENV('LANG')
AND P.PURCHASE_INTEREST = 'Y'
AND (P.DISABLE_DATE IS NULL OR P.DISABLE_DATE > SYSDATE) ORDER BY UPPER(B.CONCATENATED_SEGMENTS) ASC

Columns