Product: | XNC - Sales for Communications (Obsolete) |
---|---|
Description: | This view is intended to provide the information related to a Product, BOM etc.. which is the join of mtl_system_items_kfv, mfg_lookups, fnd_common_lookups, mtl_item_catalog_groups_kfv . |
Implementation/DBA Data: | Not implemented in this database |
SELECT MSKV.ORGANIZATION_ID
, MSKV.INVENTORY_ITEM_ID
, MSKV.PADDED_CONCATENATED_SEGMENTS ITEM_NUMBER
, MSKV.DESCRIPTION ITEM_DESCRIPTION
, MSKV.INVENTORY_ITEM_STATUS_CODE
, MSKV.BOM_ITEM_TYPE
, MFGL.LOOKUP_CODE BOM_ITEM_TYPE_CODE
, MFGL.MEANING BOM_ITEM_TYPE_MEANING
, MSKV.ITEM_TYPE
, FNDC.LOOKUP_CODE ITEM_TYPE_CODE
, FNDC.MEANING ITEM_TYPE_MEANING
, MSKV.ITEM_CATALOG_GROUP_ID
, MICG.PADDED_CONCATENATED_SEGMENTS CATALOG_GROUP
FROM MTL_SYSTEM_ITEMS_KFV MSKV
, MFG_LOOKUPS MFGL
, FND_COMMON_LOOKUPS FNDC
, MTL_ITEM_CATALOG_GROUPS_KFV MICG
WHERE MSKV.BOM_ITEM_TYPE = MFGL.LOOKUP_CODE
AND MFGL.LOOKUP_TYPE = 'BOM_ITEM_TYPE'
AND MSKV.ITEM_TYPE = FNDC.LOOKUP_CODE (+)
AND FNDC.LOOKUP_TYPE = 'ITEM_TYPE'
AND MSKV.ITEM_CATALOG_GROUP_ID = MICG.ITEM_CATALOG_GROUP_ID(+)