VIEW: APPS.ASO_PVT_PRODUCT_CATALOG_BALI_V

Source

View Text - Preformatted

SELECT i.concatenated_segments inventory_item, i.inventory_item_id inventory_item_id, i.description item_description, i.primary_uom_code primary_uom_code, i.organization_id, mic.category_id, mic.category_set_id, DECODE(i.bom_item_type, 1, 'MDL', 2, 'OPT', 3, 'PLN', 4, DECODE(i.service_item_flag, 'Y', 'SRV', DECODE(i.serviceable_product_flag, 'Y', 'SVA', 'STD'))) item_type_code FROM mtl_system_items_vl i, mtl_item_categories mic WHERE i.bom_item_type IN (1,4) AND i.serviceable_product_flag = 'Y' AND i.primary_uom_code <> 'ENR' AND i.inventory_item_id = mic.inventory_item_id AND i.organization_id = mic.organization_id AND NVL(i.start_date_active, sysdate) <= sysdate AND NVL(i.end_date_active, sysdate) >= sysdate

View Text - HTML Formatted

SELECT I.CONCATENATED_SEGMENTS INVENTORY_ITEM
, I.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, I.DESCRIPTION ITEM_DESCRIPTION
, I.PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, I.ORGANIZATION_ID
, MIC.CATEGORY_ID
, MIC.CATEGORY_SET_ID
, DECODE(I.BOM_ITEM_TYPE
, 1
, 'MDL'
, 2
, 'OPT'
, 3
, 'PLN'
, 4
, DECODE(I.SERVICE_ITEM_FLAG
, 'Y'
, 'SRV'
, DECODE(I.SERVICEABLE_PRODUCT_FLAG
, 'Y'
, 'SVA'
, 'STD'))) ITEM_TYPE_CODE
FROM MTL_SYSTEM_ITEMS_VL I
, MTL_ITEM_CATEGORIES MIC
WHERE I.BOM_ITEM_TYPE IN (1
, 4)
AND I.SERVICEABLE_PRODUCT_FLAG = 'Y'
AND I.PRIMARY_UOM_CODE <> 'ENR'
AND I.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND I.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND NVL(I.START_DATE_ACTIVE
, SYSDATE) <= SYSDATE
AND NVL(I.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE