VIEW: APPS.XNB_ITEMMST_CATS_V

Source

View Text - Preformatted

SELECT msiv.inventory_item_id INVENTORY_ITEM_ID, msiv.segment1 ITEM_NAME, msiv.organization_id ORGANIZATION_ID, ood.organization_name ORGANIZATION_NAME, msiv.item_type ITEM_TYPE, flv.Meaning ITEM_TYPE_DESC, msiv.bom_item_type BOM_ITEM_TYPE, mfl.Meaning BOM_ITYPE_DESC, msiv.primary_unit_of_measure PRIMARY_UNIT_OF_MEASURE, msiv.primary_uom_code PRIMARY_UOM_CODE, msiv.description DESCRIPTION, msiv.inventory_item_status_code INVENTORY_ITEM_STATUS_CODE, mis.description ITEM_STATUS_DESC, msiv.start_date_active START_DATE_ACTIVE, msiv.end_date_active END_DATE_ACTIVE, msiv.creation_date LAST_UPDATE_DATE, msiv.last_update_date CREATION_DATE, mic.category_id CATEGORY_ID, mcv.description CATEGORY_DESCRIPTION, mic.category_set_id CATEGORY_SET_ID, mcsv.category_set_name CATEGORY_SET_NAME, msiv.attribute1 ATTRIBUTE1, msiv.attribute2 ATTRIBUTE2, msiv.attribute3 ATTRIBUTE3, msiv.attribute4 ATTRIBUTE4, msiv.attribute5 ATTRIBUTE5, msiv.attribute6 ATTRIBUTE6, msiv.attribute7 ATTRIBUTE7, msiv.attribute8 ATTRIBUTE8, msiv.attribute9 ATTRIBUTE9, msiv.attribute10 ATTRIBUTE10, msiv.attribute11 ATTRIBUTE11, msiv.attribute12 ATTRIBUTE12, msiv.attribute13 ATTRIBUTE13, msiv.attribute14 ATTRIBUTE14, msiv.attribute15 ATTRIBUTE15 from mtl_system_items_vl msiv, mtl_item_categories mic, mtl_category_sets_vl mcsv, mtl_categories_vl mcv, org_organization_definitions ood, fnd_lookup_values_vl flv, mfg_lookups mfl, mtl_item_status mis WHERE msiv.invoiceable_item_flag = 'N' and msiv.inventory_item_id = mic.inventory_item_id and msiv.organization_id = mic.organization_id and msiv.organization_id = ood.organization_id and mic.category_id = mcv.category_id and mic.category_set_id = mcsv.category_set_id and msiv.item_type = flv.lookup_code(+) and flv.lookup_type(+) = 'ITEM_TYPE' and msiv.bom_item_type = mfl.lookup_code(+) and mfl.lookup_type(+) = 'BOM_ITEM_TYPE' and mis.inventory_item_status_code = msiv.inventory_item_status_code

View Text - HTML Formatted

SELECT MSIV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSIV.SEGMENT1 ITEM_NAME
, MSIV.ORGANIZATION_ID ORGANIZATION_ID
, OOD.ORGANIZATION_NAME ORGANIZATION_NAME
, MSIV.ITEM_TYPE ITEM_TYPE
, FLV.MEANING ITEM_TYPE_DESC
, MSIV.BOM_ITEM_TYPE BOM_ITEM_TYPE
, MFL.MEANING BOM_ITYPE_DESC
, MSIV.PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE
, MSIV.PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, MSIV.DESCRIPTION DESCRIPTION
, MSIV.INVENTORY_ITEM_STATUS_CODE INVENTORY_ITEM_STATUS_CODE
, MIS.DESCRIPTION ITEM_STATUS_DESC
, MSIV.START_DATE_ACTIVE START_DATE_ACTIVE
, MSIV.END_DATE_ACTIVE END_DATE_ACTIVE
, MSIV.CREATION_DATE LAST_UPDATE_DATE
, MSIV.LAST_UPDATE_DATE CREATION_DATE
, MIC.CATEGORY_ID CATEGORY_ID
, MCV.DESCRIPTION CATEGORY_DESCRIPTION
, MIC.CATEGORY_SET_ID CATEGORY_SET_ID
, MCSV.CATEGORY_SET_NAME CATEGORY_SET_NAME
, MSIV.ATTRIBUTE1 ATTRIBUTE1
, MSIV.ATTRIBUTE2 ATTRIBUTE2
, MSIV.ATTRIBUTE3 ATTRIBUTE3
, MSIV.ATTRIBUTE4 ATTRIBUTE4
, MSIV.ATTRIBUTE5 ATTRIBUTE5
, MSIV.ATTRIBUTE6 ATTRIBUTE6
, MSIV.ATTRIBUTE7 ATTRIBUTE7
, MSIV.ATTRIBUTE8 ATTRIBUTE8
, MSIV.ATTRIBUTE9 ATTRIBUTE9
, MSIV.ATTRIBUTE10 ATTRIBUTE10
, MSIV.ATTRIBUTE11 ATTRIBUTE11
, MSIV.ATTRIBUTE12 ATTRIBUTE12
, MSIV.ATTRIBUTE13 ATTRIBUTE13
, MSIV.ATTRIBUTE14 ATTRIBUTE14
, MSIV.ATTRIBUTE15 ATTRIBUTE15
FROM MTL_SYSTEM_ITEMS_VL MSIV
, MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORY_SETS_VL MCSV
, MTL_CATEGORIES_VL MCV
, ORG_ORGANIZATION_DEFINITIONS OOD
, FND_LOOKUP_VALUES_VL FLV
, MFG_LOOKUPS MFL
, MTL_ITEM_STATUS MIS
WHERE MSIV.INVOICEABLE_ITEM_FLAG = 'N'
AND MSIV.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MSIV.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MSIV.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND MIC.CATEGORY_ID = MCV.CATEGORY_ID
AND MIC.CATEGORY_SET_ID = MCSV.CATEGORY_SET_ID
AND MSIV.ITEM_TYPE = FLV.LOOKUP_CODE(+)
AND FLV.LOOKUP_TYPE(+) = 'ITEM_TYPE'
AND MSIV.BOM_ITEM_TYPE = MFL.LOOKUP_CODE(+)
AND MFL.LOOKUP_TYPE(+) = 'BOM_ITEM_TYPE'
AND MIS.INVENTORY_ITEM_STATUS_CODE = MSIV.INVENTORY_ITEM_STATUS_CODE