Product: | INV - Inventory |
---|---|
Description: | ERES : View to support ERES framework for Items Organization Assignment |
Implementation/DBA Data: | APPS.MTL_SYSTEM_ITEMS_ER4_V |
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