VIEW: APPS.MTL_SYSTEM_ITEMS_ER4_V

Source

View Text - Preformatted

SELECT P.ORGANIZATION_CODE , O.NAME , B.INVENTORY_ITEM_ID , B.ORGANIZATION_ID , P.MASTER_ORGANIZATION_ID , INV_MEANING_SEL.c_unitmeasure(B.PRIMARY_UOM_CODE) , INV_MEANING_SEL.c_fnd_lookup_vl(B.TRACKING_QUANTITY_IND,'INV_TRACKING_UOM_TYPE') , INV_MEANING_SEL.c_fnd_lookup_vl(B.ONT_PRICING_QTY_SOURCE,'INV_PRICING_UOM_TYPE') , INV_MEANING_SEL.c_unitmeasure(B.SECONDARY_UOM_CODE) , INV_MEANING_SEL.c_fnd_lookup_vl(B.SECONDARY_DEFAULT_IND,'INV_DEFAULTING_UOM_TYPE') , B.DUAL_UOM_DEVIATION_HIGH , B.DUAL_UOM_DEVIATION_LOW FROM MTL_SYSTEM_ITEMS_B B , HR_ALL_ORGANIZATION_UNITS_TL O , MTL_PARAMETERS P WHERE O.ORGANIZATION_ID = B.ORGANIZATION_ID AND O.LANGUAGE = USERENV('LANG') AND P.ORGANIZATION_ID = O.ORGANIZATION_ID

View Text - HTML Formatted

SELECT P.ORGANIZATION_CODE
, O.NAME
, B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, P.MASTER_ORGANIZATION_ID
, INV_MEANING_SEL.C_UNITMEASURE(B.PRIMARY_UOM_CODE)
, INV_MEANING_SEL.C_FND_LOOKUP_VL(B.TRACKING_QUANTITY_IND
, 'INV_TRACKING_UOM_TYPE')
, INV_MEANING_SEL.C_FND_LOOKUP_VL(B.ONT_PRICING_QTY_SOURCE
, 'INV_PRICING_UOM_TYPE')
, INV_MEANING_SEL.C_UNITMEASURE(B.SECONDARY_UOM_CODE)
, INV_MEANING_SEL.C_FND_LOOKUP_VL(B.SECONDARY_DEFAULT_IND
, 'INV_DEFAULTING_UOM_TYPE')
, B.DUAL_UOM_DEVIATION_HIGH
, B.DUAL_UOM_DEVIATION_LOW
FROM MTL_SYSTEM_ITEMS_B B
, HR_ALL_ORGANIZATION_UNITS_TL O
, MTL_PARAMETERS P
WHERE O.ORGANIZATION_ID = B.ORGANIZATION_ID
AND O.LANGUAGE = USERENV('LANG')
AND P.ORGANIZATION_ID = O.ORGANIZATION_ID