[Home] [Help]
View: XNC_ITEM_TYPE_V
Product: | XNC - Sales for Communications (Obsolete) |
Description: | XNC_ITEM_TYPE_V retrieves the Communications item type and other item details for an Inventory Item and Organization. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT MSI.ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID
, MSI.PADDED_CONCATENATED_SEGMENTS ITEM_NAME
, MSI.DESCRIPTION ITEM_DESCRIPTION
, DECODE(UPPER(MTLUM.UOM_CLASS)
, 'TIME'
, 'RECURRING'
, 'NON-RECURRING') ITEM_TYPE
, DECODE(UPPER(MTLUM.UOM_CLASS)
, 'TIME'
, 'RECURRING'
, 'NON-RECURRING') ITEM_TYPE_NAME
, MSI.SHIPPABLE_ITEM_FLAG
, MSI.CUSTOMER_ORDER_ENABLED_FLAG
FROM FND_LOOKUP_VALUES_VL LKPN
, FND_LOOKUP_VALUES_VL LKPR
, MTL_SYSTEM_ITEMS_VL MSI
, MTL_UNITS_OF_MEASURE_VL MTLUM
WHERE LKPR.VIEW_APPLICATION_ID = 532
AND LKPR.LOOKUP_TYPE = 'XNC_ITEM_TYPE'
AND LKPR.LOOKUP_CODE = 'RECURRING'
AND LKPN.VIEW_APPLICATION_ID = 532
AND LKPN.LOOKUP_TYPE = 'XNC_ITEM_TYPE'
AND LKPN.LOOKUP_CODE = 'NON_RECURRING'
AND MSI.PRIMARY_UOM_CODE = MTLUM.UOM_CODE
Columns
Name |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
ITEM_NAME |
ITEM_DESCRIPTION |
ITEM_TYPE |
ITEM_TYPE_NAME |
SHIPPABLE_ITEM_FLAG |
CUSTOMER_ORDER_ENABLED_FLAG |