Product: | XNC - Sales for Communications (Obsolete) |
---|---|
Description: | This view is to display products |
Implementation/DBA Data: | Not implemented in this database |
SELECT MSV.ORGANIZATION_ID
, MSV.INVENTORY_ITEM_ID
, LTRIM(RTRIM(MSV.PADDED_CONCATENATED_SEGMENTS)) ITEM_NAME
, MSV.DESCRIPTION ITEM_DESCRIPTION
, MSV.PRIMARY_UNIT_OF_MEASURE
, MSV.PRIMARY_UOM_CODE
, MSV.ITEM_TYPE
, FNDC.MEANING ITEM_TYPE_MEANING
, FNDC.LOOKUP_CODE ITEM_TYPE_CODE
, MFL.LOOKUP_CODE BOM_ITEM_TYPE_CODE
, MFL.MEANING BOM_ITEM_TYPE_MEANING
, MSV.COMMS_ACTIVATION_REQD_FLAG
, MSV.CUSTOMER_ORDER_FLAG
, MSV.CUSTOMER_ORDER_ENABLED_FLAG
, MSV.INVENTORY_ITEM_FLAG
, MSV.PURCHASING_ITEM_FLAG
, MSV.SHIPPABLE_ITEM_FLAG
, MSV.INVOICEABLE_ITEM_FLAG
, MSV.SERVICEABLE_PRODUCT_FLAG
, MSV.MTL_TRANSACTIONS_ENABLED_FLAG
, MSV.STOCK_ENABLED_FLAG
, MSV.BOM_ENABLED_FLAG
, MSV.RETURNABLE_FLAG
, MSV.INVENTORY_ITEM_STATUS_CODE
, MSV.REPLENISH_TO_ORDER_FLAG
, MSV.SERVICE_ITEM_FLAG
, MSV.VENDOR_WARRANTY_FLAG
, MSV.SERVICE_DURATION
, MSV.SERVICE_DURATION_PERIOD_CODE
, MSV.SO_TRANSACTIONS_FLAG
, MSV.PICK_COMPONENTS_FLAG
, MSV.DEFAULT_SHIPPING_ORG
, MSV.ORDERABLE_ON_WEB_FLAG
, MSV.WEB_STATUS
, MSV.COMMS_NL_TRACKABLE_FLAG
, MSV.COVERAGE_SCHEDULE_ID
, OCT.NAME
FROM MTL_SYSTEM_ITEMS_KFV MSV
, MFG_LOOKUPS MFL
, FND_COMMON_LOOKUPS FNDC
, OKS_COVERAGE_TEMPLTS_V OCT
WHERE MFL.LOOKUP_TYPE = 'BOM_ITEM_TYPE'
AND MSV.BOM_ITEM_TYPE = MFL.LOOKUP_CODE
AND (MSV.ITEM_TYPE = FNDC.LOOKUP_CODE )
AND FNDC.LOOKUP_TYPE='ITEM_TYPE'
AND MSV.COVERAGE_SCHEDULE_ID = OCT.ID (+) UNION ALL SELECT MSV.ORGANIZATION_ID
, MSV.INVENTORY_ITEM_ID
, LTRIM(RTRIM(MSV.PADDED_CONCATENATED_SEGMENTS)) ITEM_NAME
, MSV.DESCRIPTION ITEM_DESCRIPTION
, MSV.PRIMARY_UNIT_OF_MEASURE
, MSV.PRIMARY_UOM_CODE
, MSV.ITEM_TYPE
, '' ITEM_TYPE_MEANING
, '' ITEM_TYPE_CODE
, MFL.LOOKUP_CODE BOM_ITEM_TYPE_CODE
, MFL.MEANING BOM_ITEM_TYPE_MEANING
, MSV.COMMS_ACTIVATION_REQD_FLAG
, MSV.CUSTOMER_ORDER_FLAG
, MSV.CUSTOMER_ORDER_ENABLED_FLAG
, MSV.INVENTORY_ITEM_FLAG
, MSV.PURCHASING_ITEM_FLAG
, MSV.SHIPPABLE_ITEM_FLAG
, MSV.INVOICEABLE_ITEM_FLAG
, MSV.SERVICEABLE_PRODUCT_FLAG
, MSV.MTL_TRANSACTIONS_ENABLED_FLAG
, MSV.STOCK_ENABLED_FLAG
, MSV.BOM_ENABLED_FLAG
, MSV.RETURNABLE_FLAG
, MSV.INVENTORY_ITEM_STATUS_CODE
, MSV.REPLENISH_TO_ORDER_FLAG
, MSV.SERVICE_ITEM_FLAG
, MSV.VENDOR_WARRANTY_FLAG
, MSV.SERVICE_DURATION
, MSV.SERVICE_DURATION_PERIOD_CODE
, MSV.SO_TRANSACTIONS_FLAG
, MSV.PICK_COMPONENTS_FLAG
, MSV.DEFAULT_SHIPPING_ORG
, MSV.ORDERABLE_ON_WEB_FLAG
, MSV.WEB_STATUS
, MSV.COMMS_NL_TRACKABLE_FLAG
, MSV.COVERAGE_SCHEDULE_ID
, OCT.NAME
FROM MTL_SYSTEM_ITEMS_KFV MSV
, MFG_LOOKUPS MFL
, OKS_COVERAGE_TEMPLTS_V OCT
WHERE MFL.LOOKUP_TYPE = 'BOM_ITEM_TYPE'AND MSV.BOM_ITEM_TYPE = MFL.LOOKUP_CODE
AND MSV.ITEM_TYPE IS NULL
AND MSV.COVERAGE_SCHEDULE_ID = OCT.ID (+)