VIEW: APPS.AST_INV_ITEM_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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