DBA Data[Home] [Help]

APPS.OE_ORDER_CACHE dependencies on MTL_PARAMETERS

Line 1717: --Find out whether the inventory org is WMS enabled from mtl_parameters

1713: FROM MTL_SYSTEM_ITEMS
1714: WHERE INVENTORY_ITEM_ID = p_key1
1715: AND ORGANIZATION_ID = p_key2;
1716: -- Pack J catchweight
1717: --Find out whether the inventory org is WMS enabled from mtl_parameters
1718: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
1719: SELECT wms_enabled_flag
1720: INTO g_item_rec.wms_enabled_flag
1721: FROM mtl_parameters

Line 1721: FROM mtl_parameters

1717: --Find out whether the inventory org is WMS enabled from mtl_parameters
1718: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
1719: SELECT wms_enabled_flag
1720: INTO g_item_rec.wms_enabled_flag
1721: FROM mtl_parameters
1722: WHERE organization_id = p_key2;
1723: END IF;
1724:
1725: END IF;